Well you're not paying me, so I'm not going to spend hours or days on this,...

Oh a hex editor will work. I can...

I'm all for optimism, but it might be just a little bit misplaced here. http://www.sqlservercentral.com/Forums/FindPost922808.aspx

Please do. I'd be very interested in the reason for this odd scenario.

You're welcome to feel that way.

Do note that I'm not talking in ignorance here. I know a reasonable amount about corrupt databases and recovering them. I could point you...

I'm going to assume you didn't read the article I listed. Please take a minute and do so. Thanks

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If the rebuild log failed, it's game over. That's the absolute last resort and there's nothing else that can be done.

Try the data recovery tool (yes, you'll have to buy...

Are there any errors from around that time in the SQL Server error log? CheckDB execution is logged.

You sure it's a mdf file? If you're getting...

Nothing. It's just the naming standard that MS used in the adventureworks database.

Because that won't...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic922719-9-1.aspx

The recommended approach would be to restore the user databases from backup.

Since you don't have backups, check this blog post for how to force SQL to rebuild the log...

This is a SQL 2005 server?

What's the type of syskeys?

SELECT type_desc from sys.objects where name = 'syskeys'

Some other important questions.

Has checkDB been running successfully up until now?

Is this...