If the database is badly fregment, over 20min for 27GB is normal and depends on Server power, storage, etc, it can take more then half day to shrink. The best...

this might be dump question but have you setup the MSX for the job and enlist the TargetServer?

This proc is for the Multi Server Jobs that you want to...

From SQL

SELECT NEWID()

You can use RAND() function but I don't like converting the number to varchar so I'd use A globally unique identifier (GUID).

There are may other ways but...

You mean if a query uses a particular index?

If that is the case, under SQL analyzer and execution plan (Ctrl + L) fuction

Here is my 2cents

Often it wasn't just the query inside of the proc that causing that problem but problem with connection pooling between SQL server and asp(IIS). Have you tried to...

Very good point about default database. SQL2k for some application is very senstive about default login so I use this simple query to generate the script from source server and...

1) When moving a DB with the Backup/Restore Method, do you still have to create the Logins, Users, Roles, DTS Packages, Jobs, Operators and Alerts separately?

>> All depends...

Thank you Jeff and congratulation to become an official Fool

We are actually looking for Junior-Mid level SQL DBA so if you know anyone,...

You do not need to register to access the jobs.fool.com. You might see a pop-up to regisiter but you can just close it. Unless you want to navigate other products...

Just one little tip, Use "xp_readerrorlog" from SQL Analyzer to see how far got for rolling back not from EM if you ever decide to reboot.

Thank you and I already know about that bug. And it is not Windows Server 2003. :-/

I am glad that worked. I do not recommend to be the standard for this type of work though. All depends on the situation and query. Sometimes Derived query works...

Hmm.. I think, the original range check will work. Aaron, you right, it will convert to MM/DD/YYYY format but it still keeps "Datetime" type format so when you compare the time,...

Above query seems to goo and I agree w/ Douglas that often Derived query help to improve the performance.

Also, I am also curious about why proc makes dead lock not...