If you're referring to the checkDB errors that you posted on the 13th Feb then, as I posted multiple times, the errors are not repairable in any way. The damage...

Syntax Highlighter Evolved

http://www.viper007bond.com/wordpress-plugins/syntaxhighlighter/

I've got some similar complaints. Looks like the plugin that I use for code blocks translates badly. Most of the time the main page is mangled and the individual post...

Except that can...

TalkToLee (4/2/2010)

---

In our troubleshooting efforts, we simply rebooted the server and re-ran the integrity check and all worked...it is almost like that 'internal' snapshot was regenerated and THEN it worked...

I dunno, that could give the impression that failed inserts/updates don't roll back (insert 10 rows, row 8...

Just an aside, it's hard to see a long subject. Please in future post the errors in the body of the post, not the subject.

A transient DB snapshot is one...

Do you still need help in trying to recover this DB via the tran log (if possible)?

GSquared (4/2/2010)

---

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself or as part...

It's true any time the threads have to be synchronised.

What's the state of the database? (state_desc in sys.databases)

What have you done to this database to get it into this state?

That error doesn't make the slightest sense. That the error you get when you're querying for an object in the wrong database, not querying an inaccessible database.

SELECT * FROM DatabaseName.sys.objects...

If you try and query that database, do you get an error? If so, exactly what error?

If you query sys.databases, what's the state_desc for this DB?

Please remember I can't see...

Did you refresh Object Explorer?

If you try and query that database, do you get an error? If so, exactly what error?

If you query sys.databases, what's the state_desc for this DB?

So there's no DB restore happening?

What happened when you ran the RESTORE with recovery command? Was there an error? Were there any results from the query?

If you check the SQL...