Well explained and a must read for database devlopers...

Steve,

Is SSC Promo code or source code? because when I input SSC in the promo code field, it complains as an invalid code.

thanks,

jeff

Madiha,

All you need to is probably the following:

update msdb..sysjobs set originating_server = '<new server>' -- your new server name

where originating_server = '<old server>' -- your old server name

Just test all...

Sean,

It seems you work for PC Financial. Since I am a loyal customer of PC Financial, I'd like to thank you for your contribution to PC Financial services provided to...

My philosophy regarding DBA work is:

If you have too much work to do, you need to review your work process model, and see whether some componets of your daily work...

I am with you, Mike, for last 3 years as a contractor, I changed job 5 times, almost every 4 to 6 months, I will switch to another company's project....

Just wondering which type I belong to since I first replied this post.

J.Y

James,

You are a great marketing person with this ads, I like this type of lively post.

JY

Loner, I like your post. I have recently encountered the people of type 2, and my feeling is one word: Boring.

Brian, does SQLSentry cause any overhead cost on performance? I remember in SQLSentry ver2, I notice the product runs two jobs, one of which runs every minute (I guess it is...

Thanks, Kenneth for your great work to help improve my code. Really appreciate it !

Jeffrey

try count_big() to return a big integer.

HTH

J.Y

Phil, I'd prefer using "backup device" instead of physical file, because you can always change your backup device to point to another file once the disk is full for the...

I finally opened a support case with MS, and what I can say is we solve the problem at the moment but still with a big question mark.

Thanks Jason for your reminder, but, No, for 2GB RAM, no need to turn AWE on.