Thanks! That did the trick.

I thought about that. That doesn't appear to be the case. And if this developer logs into a different workstation, they can connect to the db server just...

We've resolved the issue. The DB Server needed .Net 3.5.

I'm running it from a UNC path... \\mymasterserver\folder\mine.exe. I tried setting...

I'm running sql 2005 Standard sp3 on windows server 2003 sp2.

I am seeing the error in the job history.

I am a big fan of nolock and have used it very successfully (and prudently) over the years. I must admit that this whole thread has made me reconsider...

Well... I rebooted the server and integrity checks passed after failing 2 nights in a row.

One thing I didn't mention was that we had a bad SAN drive 2 days...

Thanks for the input Gail. Checksums are enabled and have been for quite a while. It is possible that the databases were originally SQL 2000 but I'm not...

Something must have changed within the last year because, to my surprise and delight, the following now works:

SELECT * FROM MyLinkedServer.MyDB.dbo.Table1 WITH (NOLOCK)

This works from 2005 to 2000 and from...

Wow, I can't believe I didn't notice the timestamp on the CHECKDB. You've answered my question clearly. Thank you. And thanks for the article link.

Simon Villiers (6/5/2006)

By "orphaned temp tables" I mean temp tables in tempdb that no longer have any connecting processes/sessions/etc. I know they are dropped when the connection terminates, and when...

I think some clarification is needed here.

I set up a sql login called Test with no permissions (other than the default inherited through public). In SSMS I...

As far as I know, the sql server user that you describe should not be able to restart the server.

I am assuming that you tested this and found that the...

Nice article. I would just like to point out that for those of us that have numerous servers, automation of the checklist is critical. If you're dealing with...