You'd probably need to do this from the OS itself and get the notification when services shut down. In W2K you can run a command when a service shuts down...

Use the Server Network Utility.

Don,

Best of luck with Oracle. It will surely be interesting and you'll learn quite a bit.

As to your question. I've had that one before and last year when I managed...

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

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

Thanks for the followup and you might want to read Brian Kelley's article on SQL Server and Anti Virus to prevent this type of thing: http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritydealingwithantivirusprograms.asp

I like Peter's suggestion. It is easy to undo if something isn't working. Be sure that you let the others know what you've done if they might get calls about...

If they all have indexes, you can query sysobjects for types of "U" and join that with the sysindexes to get the row counts.

Chief Data Janitor and Nonsensical Blabber am I

Sure, sure, the MVPs pick on the little guys

Since object is such an over used word, I agree and it has been changed.

You should have RI implemented to solve most of this and then you will have checks based on business rules to determine if things are cnsistent.

You are correct. I checked it, but when reading the docs, they have it wrong in BOL. Points are being awarded back.

Check the settings on the maintenance plan. I think that there is a place to specify the names that will be used.

I suspect it's a choice that you make for ease of admin or skillsets rather than a technical reason.

There are some procedures for decrypting stored procedures. Search on Google.

Do you need to companre the memberOf and Member fields or can you just replace what's there with the new data? If you did that everyday, that should work.

Alternatively, and...