Viewing 15 posts - 33,181 through 33,195 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 6, 2010 at 1:12 am
Syntax Highlighter Evolved
http://www.viper007bond.com/wordpress-plugins/syntaxhighlighter/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 4:54 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 4:34 pm
Paul White NZ (4/2/2010)
GilaMonster (4/2/2010)
'Table variables are not affected by explicit transaction rollbacks'?Operations performed on a table variable within a transaction are not undone if that transaction aborts.
Except that can...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 10:03 am
TalkToLee (4/2/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 9:58 am
GSquared (4/2/2010)
I'd be specific. "Transactions in table variables can't be rolled back."
I dunno, that could give the impression that failed inserts/updates don't roll back (insert 10 rows, row 8...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 9:30 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 9:26 am
Do you still need help in trying to recover this DB via the tran log (if possible)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 9:18 am
GSquared (4/2/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 9:18 am
It's true any time the threads have to be synchronised.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 9:03 am
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 7:52 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 7:25 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 6:28 am
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 5:45 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2010 at 5:10 am
Viewing 15 posts - 33,181 through 33,195 (of 49,552 total)