Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tom Thomson » Repairing with DBCC CHECKDB
Add to briefcase
31 posts, Page 2 of 4
««1234»»»

Repairing with DBCC CHECKDB Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
L' Eomot Inversé
Posted Friday, June 15, 2012 6:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 7,110, Visits: 7,184
Apologies to everyone for the silly syntax error.

I'll ask Steve to correct the question.

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1316534
Mike Hays
Posted Friday, June 15, 2012 6:29 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:02 AM
Points: 300, Visits: 307
Agree, got the same result as the post above above about syntax error. Is there any quality control on these questions?!?!
Post #1316543
sestell1
Posted Friday, June 15, 2012 6:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:36 AM
Points: 837, Visits: 1,219
Ugh, I didn't realize that had been depreciated.
Thanks for the question Tom!
Post #1316556
Steve Cullen
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
Robert Davis
Posted Friday, June 15, 2012 7:04 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:05 PM
Points: 1,559, Visits: 1,397
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
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring
Post #1316571
Mark D Powell
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, May 21, 2013 12:26 PM
Points: 1,258, Visits: 341
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
EL Jerry
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, May 02, 2013 3:45 PM
Points: 3,748, Visits: 928
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
Post #1316624
Andre Ranieri
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 @ 4:56 PM
Points: 277, Visits: 201
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
David Smerchek
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: Tuesday, January 08, 2013 6:07 AM
Points: 1,073, Visits: 170
in SQL 2012 running this you will get a syntex error near ","
Post #1316687
mtassin
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: Today @ 7:16 PM
Points: 3,231, Visits: 64,330
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
31 posts, Page 2 of 4
««1234»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.