Checked the settings on the linked server, it was set to 0 or no limit. Checked the connection tab on the remote server and it was set to 3600...

The Remote Timeout setting is set to 3600 or 1 hour. We are timing out at 10 min. The error points to resource limitation so I was wondering...

Thank you this worked perfectly!

Thanks, but I was hoping there was a way to see an event that has already happened. It seems odd that a user account could be deleted and Sql...

with the consent of the vendor who no longer has that version of the source code, hexeditor on dll, changed upper case instance to lower.

This is solved!

Yes, Thanks, I did run the script as you have laid out.

I did verify that Lock Pages in Memory has been granted to the service account running SQL SERVER

We...

This step by step guide worked perfect for me.

I have a working copy of MSDB and a good backup!

Thanks for all the help my problem is now solved!

I did run each of the CHECKDB commands that you listed above and consistent for all is the corrupt file message.

Below is the specific message for Checkalloc. The results...

When I run the command above I get the following:

Msg 8921, Level 16, State 1, Line 1

Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space...

SQL SERVER LOG:

The entire error is as follows:

Date6/24/2008 8:30:12 AM

LogSQL Server (Current - 6/24/2008 8:30:00 AM)

Sourcespid60

Message

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x0; actual signature:...