-
Could someone give me a concise summary of the differences between EXEC and sp_executesql? Should we set standards that require the use of one over the other by our developers? Cheers
Last updated: -
Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...
Last updated: -
Upgrade to SQL Server 2005 sooner or later?
Hello, I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans? 58%...
Last updated: -
Accessing Linked Server in SQL Server 2000 (Urgent)
I have a server named say 'SRVMAIN'. Using Enterprise Manager I added a linked server 'LNKDSRVR1' (existing server). I m able to access any database in 'LNKDSRVR1' by writing a query in query analyzer of 'SRVMAIN' as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as...
Last updated: -
Convert date format from UTC to PST in SQL
HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu
-
T-SQL, and cascading updates or finding constraint names
Hi all, I have been tasked with a difficult project. My employer has a rather large database, hosted on SQL Server 2000, which is used by several thousand users across our organization, and grouped by business units. This database is evolving with each minor release, which is just about every...
Last updated: -
Upgrade from MS SQL Server 6.5 to SQL 2000 Fails
The upgrade process using Microsoft "SQL Sever Upgrade Wizard" fails at the "Import and Export via Named Pipe" part. With the following Error: Starting MSSQLServer............................... Waiting for recovery. Sysmessages # 4002 [Microsoft][ODBC SQL Server Dirver][SQL...
Last updated: -
MIgrating SQL Server 2000 to Active Directory
When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working...
Last updated: -
I just installed SQL Server 2000 on a brand new Windows 2000 SP4 server. The install did not prompt me for the CD-Key! Does anyone know why this would happen?
Last updated: -
I am an Oracle DBA learning SQL Server. Does anyone have any favorite books for SQL Server 2000. I am looking specifically for books geared towards everyday tasks performed by a DBA.
Last updated: