Good Day Sam,

Here's the code that your developer probably needs (it's from today's SQL Server Central emailing !):

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1753

You do not have to go out to xp_cmdshell. One must merely 'qualify' the execution. An example I use all of the time:

use master

go

exec some_other_database..sp_changedbowner 'sa'

go

This works well. Now all...

I would assume that it is possible in VB. As for a stored procedure no. Besides, if you can execute a stored procedure you have already connected to the SQL...

No. EM is client software. Exisiting databases running on the server will be unaffected.

hmmm ... pass versus 1-2 training courses ... add in travel and lodging ... hmmm another 2-3 training courses ... I'm lucky to get 1 course budgeted (maybe another due...

PASS or training ... hmmm ... training !

You cannot restore a SQL 2000 backup to SQL v7.0. Your chosen method of using DTS is the correct solution.

Steve, it sounds as if you shave not shortened the transaction log backup interval from 1 hour to 15 minutes yet ...

It sounds like it is now time to recover the amster database from your last full backup. Once you perform this you should be able to start up the instance....

sp_dboption will go away eventually. You need to use ALTER DATABASE instead. It has all of the command options that you need.

I have had no difficulty in migrating SQL 2K SP3A, hot fix 818 to Win 2K3. I've moved individual servers, clusters, servers with less than 4 Gb of RAM and...

My logic seemed to indicate summer solstice in the northern hemisphere equates to winter solstice in the southern hemisphere. But before posting I used my favorite DBA reasource - Google...

Yelena,

Sorry I missed a part of your post (one of my clusters was and still is misbehaving). I agree with you on being careful and the risks involved. Whenever we...

I disagree ... using the SQL Server network utility for aliasing is a multiple computer maintenance nightmare potentially. The easiest (and probably best) method is to use DNS aliasing - after...

Have you tried to use perfmon on the NIC interfaces ? My guess is that if you used perfmon (locally) whilst you performed the network SQL trace and the local...