Thank you John, your second post answered my question. Just for my own understanding, can you explain why they have to be from the same server/database?

Thanks Martin for your input. I think I will stick with 2GB size.

Thanks for yoru help. I tried that and object_name(1852795252) and it doesn't return anything. That's why I think that perhapse it is a table that created by one...

Yes, unfortunately that is the case and has happened 4 times in the past 2 weeks. The thing is that the second object in the error is always presented...

Thanks for your help Ray. I am running the object_name in the right database. And I did run a query against sysobjects and nada. I am...

Thanks Ray, I understand that, but the error clearly says that the object id is 750065858, but when I run the select object_name(750065858), I get null.

I ran into this problem...

Thank you gentlemen.

Great, thank you for clearing that up for me.

You didn't run the dbcc shrinkfile, run that and your file will shrink.

Question for the experts here, is dbcc shrinkfile('log_file', truncateonly) the same as the option "Compress pages and then...

Yes, that's it Linda. Thank you!

Also, is there a way to tell SQL 2K to commit all transactions in a database? Just want to make sure that all transactions are commited to disk before...

Thanks for the help Joseph.

Yes, I can get that much down time. I am not able to back up the logs of this database...getting some errors when I try...

Thank you very much!

Hey, that worked! I basically made a backup of the database FILES. Then reinstalled sql server and restored the database files (including the system database files) and started...

Got you, thank you! I'll try that approach and let you know what happens.

Then I'll jump off the cliff...I rebuilt this server this past Saturday and I think my...