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...

For multiple operators, I usually send to a general box somewhere and then let the email system either forward to multiple people or one.

If you don't have SMS or MOM, then this is a pain. I might psexec it, logging the results to each server.

That or get a bunch of terminal server sessions...

Definitely use SHRINKFILE, but be sure that you don't need that space. HAving the log shrink and grow is a waste of resources.

I wrote about this some time ago for SQL 2000. Basically the file extended properties and the version in master could conceivably be different. I'd check both and that might...

You should use ALTER INDEX with 2005 and above as DBCC REINDEX is deprecated.

I'm not sure what you can grab here, though checking @@ERROR and related variables after the command...

I'd also recommend 37 Signals to check out. They have an interesting blog.

I heard Jason Fried speak recently and he talked a bit about how they build software and their...