I had a similar problem a few years ago, and added a SQL Agent job to run every 10 minutes or so and compare the size of tempdb to the...

SQLArcher (1/7/2011)

It depends on the nature of the system. I work in a financial institute with a lot of trading; in a downtime vs. partial data loss situation business has...

For almost everything I do other than reading email - screen size is critical. I can't imagine trying to look through the Event Log or research a problem with...

You might want to look at the WMI Event Watcher task in SSIS 2008. Kirk Haselden has an example of monitoring a directory for a file to be created...

I often get ideas from being dissatisfied with something, and thinking there has to be a better or easier way.

It may resolve database and server settings, but I don't think it will correct naming convention policy viloations with the click of a button.