Standard Edition 2000 Questions and Answers

Recent IT Questions

1 - 10 of 10
<<PREVIOUS 1 NEXT>>

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
Administration, Migration, Hardware
asked by nbellistri

  0 pts.

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

View Answer   |  Jul 15 2005  10:19 AM GMT
Tech support, Administration, Migration
asked by RobynLorusso23

  0 pts.

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

View Answer   |  Mar 23 2005  10:47 PM GMT
Tech support, Administration, Migration
asked by bakash

  0 pts.

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

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

  0 pts.

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
SQL, SQL Server, Standard Edition 2000
asked by sonotsky

  660 pts.

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
Tech support, Administration, Migration
asked by HenryKafeman

  0 pts.

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

asked by jpotucek

  0 pts.

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
SQL Server, Standard Edition 2000
asked by oradba13

  0 pts.

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
SQL Server, Standard Edition 2000
asked by oradba13

  0 pts.

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
SQL Server, Standard Edition 2000
asked by Douglasnz

  0 pts.

1 - 10 of 10
<<PREVIOUS 1 NEXT>>