Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Repairing with DBCC CHECKDB Expand / Collapse
Author
Message
Posted Friday, June 15, 2012 6:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:16 PM
Points: 7,738, Visits: 9,487
Apologies to everyone for the silly syntax error.

I'll ask Steve to correct the question.


Tom
Post #1316534
Posted Friday, June 15, 2012 6:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 21, 2014 2:58 PM
Points: 545, Visits: 574
Agree, got the same result as the post above above about syntax error. Is there any quality control on these questions?!?!
Post #1316543
Posted Friday, June 15, 2012 6:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 1,344, Visits: 2,321
Ugh, I didn't realize that had been depreciated.
Thanks for the question Tom!
Post #1316556
Posted Friday, June 15, 2012 6:58 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 8:39 AM
Points: 595, Visits: 1,226
QOD <<FAIL>>

Converting oxygen into carbon dioxide, since 1955.

Post #1316565
Posted Friday, June 15, 2012 7:04 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, September 26, 2014 5:09 PM
Points: 1,618, Visits: 1,548
Since the syntax error due to the comma wasn't one of the choices, I assumed the comma was a typo and answered the question as if it wasn't there. Got it right.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1316571
Posted Friday, June 15, 2012 7:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 1,378, Visits: 399
The question specifically states 2008+ and on 2008 the syntax is invalid. The first answer is the correct answer, not the answer you indicate.
Post #1316588
Posted Friday, June 15, 2012 7:43 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 4:18 PM
Points: 3,778, Visits: 1,182
Got me on this one because I read an old version of BOL. I knew there was a syntax error but I focused only on the words and not the punctuation.

I should pay attention to versions in later QOTDs.

Happy weekend everyone!!!

"El" Jerry.


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.
Post #1316624
Posted Friday, June 15, 2012 7:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:24 PM
Points: 287, Visits: 306
I got this one wrong (or right) because my answer assumes that DBCC CheckDB requires a database name, and in parentheses. At any rate, I didn't get the point but it was nice to brush up on some SQL history.

Thanks.
Post #1316645
Posted Friday, June 15, 2012 8:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 1,077, Visits: 193
in SQL 2012 running this you will get a syntex error near ","
Post #1316687
Posted Friday, June 15, 2012 8:30 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 7:42 AM
Points: 3,688, Visits: 72,435
I got this right because my copy of Local Transact SQL Help says as does BOL

' database_name ' | database_id | 0
Is the name or ID of the database for which to run integrity checks. If not specified, or if 0 is specified, the current database is used. Database names must comply with the rules for identifiers.

REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD
Specifies that DBCC CHECKDB repair the found errors. The specified database must be in single-user mode to use one of the following repair options.



I read it such that if you don't specify a database it will default to the current one. I guess not with the REPAIR commands?

Originally I thought it was an error... but reading that it seems that it should be right... it's not... but I think it should be.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1316690
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse