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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 5:59 PM
Points: 8,748, Visits: 10,577
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


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, August 27, 2015 1:02 PM
Points: 672, Visits: 710
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 1,642, Visits: 2,766
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: Yesterday @ 12:34 PM
Points: 1,624, Visits: 1,578
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 MVP
Principal Database Architect (consultant) at DB Best Technologies
Post #1316571
Posted Friday, June 15, 2012 7:18 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, July 28, 2015 2:18 PM
Points: 1,477, Visits: 423
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: Tuesday, August 25, 2015 9:46 AM
Points: 3,809, Visits: 1,265
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-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, March 4, 2015 2:28 PM
Points: 478, Visits: 375
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: Thursday, December 4, 2014 1:52 PM
Points: 1,077, Visits: 199
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 @ 2:16 PM
Points: 3,688, Visits: 72,450
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