Standard Edition 2000

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:...

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? ...

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...

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...

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...

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...

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?

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.

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