You and I both!

I don't think any of this will fade away. Are cars that much better than they were 30 years ago? I still see lots of mechanics out there.

I know TVs...

Thanks for the comments and that's a great idea for 10 ways to get promoted. I'll work on that one. Not sure I have 10 ways, but I have a...

Leaving aside the nonsense on the builds and the apparent confusion from MS on what fixes what.

I still stand by the answer that you only need to apply the latest...

Can't keep SIDs, but you can use sp_help_revlogin to script out and move logins with the same passwords.

It's a parameter in the service startup, so it should be in the registry. You can get it from xp_regread or any registry scripting

But did you get to keep the red stapler?

I think I was there in the closet/turned server room. Just behind the rack to the left.

Hugo, I'm not sure that invalidates the answer. Whether you are on the QFE track or the GDR track, you only apply the latest hotfix that you want to apply....

This is close to what I've been asking for. I was hoping for quarterly service packs, but rollup hotfixes work just as well.

Plus they shouldn't have features!

xp_fixeddrives

Or maybe use VBScript and the FileSystemObject. That might be the easiest.

I used to keep the same sa password on every production server. Different passwords for dev and QA. I'm not sure it's a bad security risk, especially given the hassles...

My understanding is that Bulent is correct. Enterprise edition allows unlimited instances, but Standard must be licensed in each VM.

Image from Denby to review at: http://www.sqlservercentral.com/forums/images/denverdavis_ERD.GIF

It will be mostly a trial and error. I've seen 1.5 largest table or even 2x largest table for the data movement. For the log, depends on rows and will...

http://www.sqlservercentral.com/columnists/sjones/datamigrationquicklyinsertingnewdata.asp

Get a list of servers into Excel, setup a "isql -S" in one cell, "sp_password null, new, sa" in the other and combine those with the server name into a...