|
|
|
March 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Microsoft recommondation. Posted by Rogers at 2/28/2006 5:26:11 PM I have one server that contains Database server, Application server and
domain controller.
What microsoft recommond to boost up the performance? to separate all the
server or separate only domain controller and make Database and Application
as a one server?
Thanks in advance. urgently ne...more >>
Client for SQL Server 7.0 Posted by aschrage16 at 2/28/2006 7:15:45 AM Are either of the programs below full featured clients for SQL Server
7.0? I am having difficulty reindexing my database for the first time--
i.e. I get no feedback from the server from a dbcc dbreindex command.
It appears that my syntax is correct:
DBCC DBREINDEX(tablename,'',85)
The state...more >>
unknown column 'state' in field list Posted by Nospam at 2/25/2006 4:44:45 AM I installed a script that is suppose to accept paypal, however on trying to
test a payment, I get this error msg:
Error
Database access error
and I get this error msg emailed to me:
Unknown column 'State' in 'field list'
Query: 'INSERT INTO `TransactionsMembership` (ID, Sum, State ) ...more >>
Licensing question Posted by Lance at 2/22/2006 6:00:29 AM Sorry if this is a little fuzzy but I have sql 2000 5 processor license and I
also have 6 developers who need the client tools. Can I install the client
tools on their pc's without violating the license agreement. In other words
can the client tools be redistributed in a development environmen...more >>
OLEDB vs ODBC Posted by mason at 2/21/2006 5:01:27 PM I am new SQL Server 2005. The native client supports both OLEDB and ODBC
connections. Which one should I prefer and why? Thanks.
...more >>
Sql Server 2005 Installation question Posted by Marc at 2/21/2006 5:49:17 AM I have installed Sql Server 2005 Enterprise but I do not have the managment
studio to view the DB instance. I can see Sql Enterprise from my Sql Server
Studio Express Management Studio. Is there a way to add management studio
for the Sql Enterprise after installation or is there an I can cli...more >>
Function Decryption Posted by Roger at 2/20/2006 11:06:13 PM I would highly appreciate if any one can let me know the Decryption of one
of mine function. One of the database developer created that functions and
he is no more in my organization and now I want to decrypt that function. I
don't have a source, can any one give me any way ???
Thanks
...more >>
Diagnose SQL Procedures. Posted by Rogers at 2/16/2006 6:07:36 PM Hi there,
Is there any way I can create one user defined stored procedure that will
let me know all the stored procedure and functions in current database have
compiled successfully, there is no compilation error in the stored
procedures ?
Basically, I have a database and there are aroun...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MS Access as frontend to SQLServer 2005? Posted by AxelHecker at 2/15/2006 2:10:30 AM It seems that I cannot create an MS Access project (ADP) to SQLServer 2005 as
I could with SQLServer 2000?
My MS Access has version 2002, SP3.
Any solution for this problem available? Thanks for any hint.
Axel Hecker
...more >>
sqlquery question Posted by Patrick F at 2/15/2006 1:22:27 AM How do you get the result from one store procedure?
i have first this procedure (CheckIfUserIsInDatabase):
.....
DECLARE @selectrowcount int
SELECT @selectrowcount = count(*) FROM Users WHERE Username = @Username
IF (@selectrowcount > 0)
BEGIN
RETURN 1
END
RETURN 0
....
...more >>
computer unable to connect to sql Posted by PaulD at 2/13/2006 4:48:46 PM My specific computer is not able to connect to SQL through ODBC link, anyone
have any ideas what can block a computer? Please read relevant information
below
-Other users on their computers can log into database using DNS
-I can log into database if I am logged onto a different computer
-Othe...more >>
drop and create in the same script in management studio Posted by Quinn at 2/10/2006 7:10:48 PM In SQL 2000, we could generate the drop and create statements for an object
in the same script. I have not been able to do this in management studio. Am
I missing something?
...more >>
Can not connect to SQL 2005 Posted by Michael Tissington at 2/10/2006 4:40:26 PM I have SQL 2005 installed on a server.
The client is trying to connect to the server, I can create an ODBC
connection but when when software tries to connect using ADO I get the
following error
"To connect to this server you must use SQL Server Management Studio"
What do I need to ins...more >>
Dynamic Query in View Posted by Rogers at 2/10/2006 10:18:14 AM Can I use variable name in the view? because the result set is depend on
different database not the same database, so I am wondering if I can use
this as a dynanice query in the view then my problem would be solved.
Thanks in advance
...more >>
Unable to view all procedures in management studio Posted by Quinn at 2/8/2006 9:52:31 PM I manage access to our databases via global group. All of the developers on
my team are in this global group. In our testing environment I only grant
this global group read access to the database. In SQL 2000, even with this
limited level of access, users are still able to see all objects in Q...more >>
SQL enterprise manager regisrations Posted by Anthony L. at 2/6/2006 1:34:25 PM we have a WIn2000 desktop and to be re-imaged with WIndows XP very soon,
any easy way to export/import all SQL servers registrations in Enterprise
Manager
it would be very painful to re-enter all these over 50 serer registrations
by hand...
???
also, the next step : if we're going to use S...more >>
Last Insert Id - MSSQL Posted by Tom at 2/4/2006 2:42:00 PM Is there any solution? Do you know some and would like to share? Please
Tom
...more >>
Is it possible to link via ADODB from an Access 2K .mdb file? Posted by Oliver at 2/3/2006 7:41:57 AM Hi all,
I am a newbie to SQL server and I am trying to link via ADODB from an Access
2000 .mdb file in Visual Basic to SQL server but I receive an error during
compilation at the "Dim rs As ADODB.Recordset" statement already.
It works if I do the same from an Access project file.
I assume...more >>
SSMS "open table" Posted by Curt at 2/2/2006 2:26:39 PM When I first loaded SQL SERVER 2005 onto my test box, I've noticed that on a
few tables I was able to right-click on a table and select "open table" and
it would open the table, but this wouldn't work on all tables. I don't
recall which tables allow this and which didn't. Now almost two mont...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |