Thank you everyone!

To add to this, I did not recover the system databases, is that something that I should have had to do in order to get the local packages? If...

Thanks a bunch for the link, it is very helpful!

Steve,

How do I save my login scripts? We have RAID in place.

I found the problem on microsoft.com. I ran the EXEC command at the bottom of this page:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q288411&

I am using DTS to load the table. Also, I know why the insert of 1 row did not work, I didn't hit enter (DR & LF) at the...

I ran it and here is the result:

The current compatibility level is 80.

I have also tried loading a test file with one column/three rows. I still get the same...

Andy,

How can I check the compatibility mode? Also, what can I do to fix this problem?

I didn't find anything pertaining to any users being online. However, I saw this:

"Bypassing recovery for database 'HJTA' because it is marked IN LOAD."

What does that mean?

...

I am sorry, never mind, it is now working. But it is odd that it was just sitting there for 15 minutes. Whats more weird is it started...

When I run DBCC CHECKDB ('DATABASENAME', REPAIR_REBUILD) I get the following message:

The repair level on the DBCC statement caused this repair to be bypassed.

Any ideas how to run CHECKDB and...

This solution doesn't work for me. I have got the following error:

"Table Corrupt: IAM page (1:356204) (object ID 1458104235, index ID 0) is out of the range of this...

Regarding the Table Corrupt error:

The Object ID exists in multiple databases for different objects, so the Table Corrupt error tells me nothing. What is the 1:2537049 numbers?

I saw the nocount option in the EM using the steps in your third post.

I also ran sp_configure, but again the nocount does not "stick".

I ran DBCC CHECKDB on all of my databases on that server. The results of only one database returned errors.

Here is one of the errors:

"Server: Msg 8906,...