This is what happens when I respond to posts before coffee - thanks for that Gail!

:crazy:

Perry - thank you for confirming this. I knew it was a DBCC command that needed to be issued. The problem is that we have no idea when...

Gail, this is perfect! Thank you again!

Thank you Gail!

🙂

Just one last question to you...I am being told that the WITH(NOLOCK) hint is used because it is speeding up response time to queries that have it in...

Paul, that was my whole point to him as well. I'm still fairly new over here, so trying not to rock the boat too much.

Also - if either you...

Thanks for the confirmation on this Gail. Is there any good reason you can think of to always be using the WITH(NOLOCK) hint in all queries? This is...

I am using SQL 2005, and it returns nothing in my result set except for the columns header.

Hi opc...It was a timing thing to determine how long a database would be available that we are doing slow boat to china copy jobs from. It's a copy...

Thank you! Sorry I did not find this myself in BOL.

P.S. The table not existing on the LinkedServer is by design...If the only way for me to get this to work is to create a blank copy of the...

Hey G!

Thank you so much for getting back to me so quickly. Yes - I am needing to do a SELECT INTO because the tables does not exist over...

That's for 2008 R2. If you look at it for 2005, it does not specify that.

Their front-end application may be the reason for why they have remained on SQL Server 2005 all this time. As opposed to trying to convince them to go with...

Lowell sir - you are GENIUS! Thank you so much! I disabled the trigger, and am back in business.

My question is though - this was only happening in...

Hi Lowell!

I just now before coming out here, delete all of my .mdf/.ldf files from the original instance, and also got rid of directories and files that were created for...