HI,

We use to use a combination of scripts, but the logistics and management of these became overwhelming. We now use a third party tool called SQL Compare from Redgate. I...

Hi Brian, any thought as to why MS does this and why in the master  database, and not a user database? ie: why not place these types of sp's in...

Excellent. It works!

Very weird ... it worked using another server (os = win server 2003) .. no reboot required ...

Hi,

We ran sp_updatestats ... but it did not change the differeneces. What we've determined is that EM is using the value from sysindexes "rowcnt" column which is a different number...

Hi, thanks for the response. The 3rd option is the method I wish to use. I don't want to select the "include dependent objects" as it will drop dependent objects in...

Hi Wesley, this method does work! Any idea why the @@servername returns NULL and this method doesn't?

Hi,

I have a developer that would like to determine what data in a column/table violates the constraint once the constraint has been re-enabled.

thanks.

Turned out to be #2 ... we used a network IP sniffer to block. Thanks for the advice.

Ed ... just performed several tests from the NT side ... NT supercedes ... many many thanks to your posting ... the clouds have lifted ...

Hello to all, thanks you for your suggestions. I appologize for cross posting, but thought this was a better venue to seek guidance.

The user is not a super user, or...

awilbur77 ... thank you for your insight into this potentially serious security loop ... but I suspect you've forgotten the professionalism part of a DBA code of ethics ...

Hi Steve,

Do a simple test ... create a MSSQL user and grant access to database.

Hi awilbur77 ... not neglected ... but not really the answer I was looking for ... my...

Hi,

I tested a MSSQL Authentication account user. Our environment is mixed mode, so scenerios/suggestions for both accounts (SQL & NT) would be very much appreciated.