I'll ask the obvious question: do the developers need access to the production data? The database objects, that I can understand. But I'm always leary about giving access to production...

Seize the day and all that, right, Robert?

I have seen VSS corrupt an entire repository (without user error), but that was back in 1999. The product has advanced quite a bit since then.

True, that one also has implicit permissions to alter the database schema.

I believe that it will allow you to allocate the maximum, but without the /PAE switch, the maximum SQL Server will actually use is 2 GB (3GB if /3GB is...

Perfmon and Task Scheduler do not properly show the memory utilization when AWE is enabled. You can use DBCC MEMORYSTATUS as per these Microsoft KB article (the SQL Server 2005...

That means there is a prepared SQL statement. Look for an sp_prepare statement prior to that. Worst case scenario, add the showplan events (make sure you get the right columns)...

This is an MSDE instance. Are there any other instances of SQL Server on this machine?

If you're talking a customer who has purchased your product and you want to ensure they don't violate their # of licenses, you're likely going to need a physical device...

When you execute SELECT @@VERSION, what do you get back? Also, when you check the sqlservr.exe file, what does the file version say?

Take a look at the new versions, especially with Team Foundation Server. You can find more info at:

Team Foundation Server Team Center

and

VSTeamSystemCentral

How are you checking for the existence of the database?

If you're going to support production on SQL Server 2000 for as long as a time period as you indicate (up to 6 months before you upgrade), take the SQL...

Failover clustering is controlled by the cluster service, which is part of the operating system. This isn't related to SQL Server, with the exception that SQL Server 2000 Enterprise and...

Look at the GRANT command in Books Online:

Books Online: GRANT