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 @ 11:12 AM
Points: 7,791, Visits: 9,545
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: Wednesday, October 15, 2014 11:36 AM
Points: 551, Visits: 580
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: Friday, October 17, 2014 10:51 AM
Points: 1,358, Visits: 2,362
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: Monday, October 13, 2014 4:42 PM
Points: 1,618, Visits: 1,549
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: Tuesday, October 7, 2014 7:29 AM
Points: 1,384, Visits: 401
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: Thursday, October 16, 2014 4:52 PM
Points: 3,780, Visits: 1,195
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: Tuesday, October 7, 2014 6:59 AM
Points: 290, Visits: 312
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: Monday, September 29, 2014 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: Tuesday, September 30, 2014 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