Viewing 15 posts - 34,021 through 34,035 (of 39,736 total)
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
May 13, 2005 at 9:09 am
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...
May 13, 2005 at 9:07 am
If they all have indexes, you can query sysobjects for types of "U" and join that with the sysindexes to get the row counts.
May 13, 2005 at 9:06 am
Chief Data Janitor and Nonsensical Blabber am I ![]()
May 12, 2005 at 3:28 pm
Sure, sure, the MVPs pick on the little guys ![]()
Since object is such an over used word, I agree and it has been changed.
May 12, 2005 at 10:24 am
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.
May 11, 2005 at 10:30 am
You are correct. I checked it, but when reading the docs, they have it wrong in BOL. Points are being awarded back.
May 10, 2005 at 10:46 am
Check the settings on the maintenance plan. I think that there is a place to specify the names that will be used.
May 9, 2005 at 10:28 am
I suspect it's a choice that you make for ease of admin or skillsets rather than a technical reason.
May 9, 2005 at 10:28 am
There are some procedures for decrypting stored procedures. Search on Google.
May 9, 2005 at 10:26 am
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...
May 5, 2005 at 10:31 am
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.
May 5, 2005 at 10:29 am
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...
May 5, 2005 at 10:28 am
thanks for the update.
May 5, 2005 at 10:28 am
Igor,
Thanks. Would you like to post some of these in the script section?
May 5, 2005 at 10:27 am
Viewing 15 posts - 34,021 through 34,035 (of 39,736 total)