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 9:21 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Thursday, August 27, 2015 3:34 PM
Points: 32,358, Visits: 16,679
The typo has been corrected and points awarded back.

My apologies for the typo.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1316724
Posted Friday, June 15, 2012 9:28 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
As a point of intellectual curiosity, when I run this against my sandbox database (SQL 2008 R2) I get an error that the database needs to be in single user mode.

Thanks again for everything. I start every morning with the SSC QoTD, and it has taught me an awful lot.

Andre Ranieri
Post #1316734
Posted Friday, June 15, 2012 9:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
Thanks for the question - cheers
Post #1316743
Posted Friday, June 15, 2012 11:01 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 25, 2015 6:27 AM
Points: 1,639, Visits: 2,013
Good question. I knew it wasn't valid any more but had forgotten that it wouldn't error.
Post #1316799
Posted Monday, June 18, 2012 11:18 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 7:27 PM
Points: 19,175, Visits: 17,473
Thanks Tom.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1317457
Posted Monday, June 18, 2012 11:29 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Monday, August 17, 2015 4:10 PM
Points: 490, Visits: 254
Easy one and no repairs would be done in this case.

Thanks.
Post #1317465
Posted Tuesday, June 19, 2012 2:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:49 AM
Points: 2,017, Visits: 7,325
Am I allowed to complain that I got an error because I have no such database as Adventureworks?

I knew that repair_fast no longer worked, but guessed wrong that it would fail with an error rather than just being ignored. I hate it when MS do this - backward compatibility is all very well but in some cases can lead you to think that an action has completed successfully rather than doing nothing! Am I the only one who'd rather start getting error messages so I knew I had to fix my code?
Post #1317766
Posted Wednesday, June 20, 2012 2:45 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, August 26, 2015 9:28 AM
Points: 8,738, Visits: 10,565
[b]I knew that repair_fast no longer worked, but guessed wrong that it would fail with an error rather than just being ignored. I hate it when MS do this - backward compatibility is all very well but in some cases can lead you to think that an action has completed successfully rather than doing nothing! Am I the only one who'd rather start getting error messages so I knew I had to fix my code?

You're certainly not the only one. A warning message might be OK instead of an error, but quietly doing nothing is irritating.

edit:spelling!


Tom
Post #1318980
Posted Thursday, August 9, 2012 8:33 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, June 16, 2015 2:34 AM
Points: 424, Visits: 60
Good question!
Post #1342694
Posted Saturday, October 6, 2012 7:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 20, 2015 12:21 AM
Points: 2,078, Visits: 2,647
hi,
Can anyone tell me How to check whether the database is in single user mode or multi user mode?



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1369424
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse