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

View Answer   |  Jul 25 2005   12:16 AM GMT   |  asked by nbellistri
Hardware, Database Management Systems, SQL Server

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

View Answer   |  Jul 15 2005   10:19 AM GMT   |  asked by RobynLorusso23
Database Management Systems, SQL Server, Administration

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' asSELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLENow if I have server as 'linkedserver'....

View Answer   |  Mar 23 2005   10:47 PM GMT   |  asked by bakash
SQL Server, Administration, Availability

Convert date format from UTC to PST in SQL

HI FriendsIs there any way to convert date format from UTC to PST?Thanks and RegardsAshu

View Answer   |  Mar 10 2005   3:30 AM GMT   |  asked by ashug8bangalore
Database Management Systems, SQL Server, Standard Edition 2000

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

View Answer   |  Feb 15 2005   10:09 AM GMT   |  asked by sonotsky
SQL Server, Standard Edition 2000, SQL

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

View Answer   |  Dec 10 2004   12:48 AM GMT   |  asked by HenryKafeman
SQL Server, Administration, Backup & recovery

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

View Answer   |  Sep 17 2004   12:40 AM GMT   |  asked by jpotucek
Tech support, Database Management Systems, SQL Server

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?

View Answer   |  Jun 4 2004   11:14 AM GMT   |  asked by oradba13
Standard Edition 2000, SQL Server

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.

View Answer   |  May 19 2004   4:36 PM GMT   |  asked by oradba13
Standard Edition 2000, SQL Server

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

View Answer   |  May 12 2004   4:52 PM GMT   |  asked by Douglasnz
Standard Edition 2000, SQL Server