SQL Server worst practices
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: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1071463,00.html. In response to this tip, several readers [...]

Answer Question   |  July 26, 2005  12:16 PM
Administration, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Development, Hardware, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Version 7 and earlier

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% delays had no [...]

Answer Question   |  July 22, 2005  10:19 AM
Administration, Architecture/Design, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Implementation, Installation/Upgrade, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Tech support, Version 7 and earlier

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 ‘linkedserver’. Again I added a linked server in [...]

Answer Question   |  March 24, 2005  10:47 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support

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

Answer Question   |  March 10, 2005  3:30 AM
Database Management Systems, SQL Server, Standard Edition 2000, T-SQL

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 month. On occasion, I’m asked [...]

Answer Question   |  February 18, 2005  10:09 AM
SQL, SQL Server, Standard Edition 2000

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 Server] Login failed I am using a Network connection between a Windows 2000 Server PC running SQL Server 2000 and [...]

Answer Question   |  December 13, 2004  12:48 PM
Administration, Backup & recovery, Implementation, Installation/Upgrade, Migration, SQL Server, Standard Edition 2000, Tech support, Version 7 and earlier

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 properly (Server and accounts [...]

Answer Question   |  September 20, 2004  12:40 PM
Biometrics, Database Management Systems, Digital certificates, Identity & Access Management, provisioning, Security tokens, Single sign-on, SQL Server, Standard Edition 2000, Tech support

SQL Server Install
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?

Answer Question   |  June 4, 2004  11:14 AM
SQL Server, Standard Edition 2000

SQL Server Books
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.

Answer Question   |  May 20, 2004  4:36 PM
SQL Server, Standard Edition 2000

EXEC and sp_executesql
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

Answer Question   |  April 12, 2011  4:52 PM
SQL Server, Standard Edition 2000