Working my way though college (and later) as a bartender/waiter, got to try lots of things I might not otherwise have done so.

Now I like to relax with a nice...

IF you are using something like a maintenance plan, and that's a good idea as you get started, be sure you enable logging. When something fails, check the log file,...

The order of the SELECTs shouldn't matter, AFAIK. The query optimizer is supposed to know what is where in a partitioned view and not query those sets that don't apply.

Not...

Couple things, is the type of job an OS job?

Also, you might need to give the entire path to cscript to get it to run. I'd run a dir *.*...

Congrats for passing the exam!

I'd agree that moving to 2008 makes more sense. It kind of "includes" all the 2005 knowledge.

Sorry, sp_trace_setstatus

http://msdn.microsoft.com/en-us/library/ms176034(SQL.90).aspx

Something must be starting it.

Don't forget that cloning doesn't mean you ignore data safety/control issues. Keep that production data safe! Even in test VMs.

You'll also need a column in your query for the table or something else to group by.

For your results, not sure what the values mean.

http://www.sqlpass.org

you also need to define what "won't work" means.

No, we don't have...

sp_stop_trace as well to shut it down.

I'd look if this is in the startup folder, or perhaps its' a service. You can disable it and then figure out if you...

Andrew,

Great job and I'm glad you wrote the article. When I saw you mention it, I was surprised as it seems many other people were today. It's a great idea.

AD is distributed, living on multiple servers, so I'm not sure what you're getting at with the AD database.

Lots of people do run DNS/AD DC (domain controllers), and DHCP on...

For the most part I'm with you...