The cursor thing isn't a big deal for adding these. It's a one time loop.

For the programming, you want to avoid them and just write out the statements. Not sure...

tempdb is highly dependent on activity and data sizes. If you have a 500MB database, 10GB is way overkill.

Disk space is cheap, and it makes sense to just assign some...

Even if the disk fills up, data can be interested into a database provided it does not need to grow. Databases typically have free space in them, and if yours...

You have a full log file. Are you running backups? Is msdb in simple recovery mode or full?

Please post your question in the edit box, not the title.

I'd definitely look at SS2K8. There are bugs, but overall it's a more mature, stable version of SS2K5.

Possibly. Not sure if that patch hits shared components or not.

Why not setup a separate instance on another test machine, or even in a VM? I wouldn't gamble with production.

I'd rename the table. That will tell you if it's still being used.

Quick.

You have to connect to each SQL Server and run this. There isn't another way.

You can write a script using sqlcmd to do this, looping through the list of servers,...

Nope, good to call me out. I probably am missing more.

I've not really used WSUS since I want control over when and where they are applied to which machines. I...

If you want to overwrite backups, use the same file name and the WITH INIT clause. However this isn't a great practice. If it fails partially in there, you don't...

Pick the indexes and right click, select delete or drop.

Best you can, though most people have smaller environments and have to make guesses on performance. I would think the data size is the most important, get all data, then...

Which event is this? If you are grabbing stored procs, you'll get it. You can filter by database or user as well.

What does the proc do?

Paul's got it. tempdb is recreated, might not have enough space for that on your system or even logging.

Lots of VBScripting.

Transfers are always easier to one file name. You could use the Dynamic Properties task to alter the connection to the file to a different name based on...