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

Are you at the latest service pack? I know there were some leakage issues with the XML stuff. PSS might have a special hot fix for it as well.

No difference really. The job would run a stored proc of a DTS package, but the DTS could run your proc. If you have more than one task or want...

thanks for the update.

Igor,

Thanks. Would you like to post some of these in the script section?