Can dbcc be run from the cmd prompt?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jon Reade » Can dbcc be run from the cmd prompt?

Can dbcc be run from the cmd prompt?

Rate Topic

Display Mode

Topic Options

Author

Message

asher-594413

Posted Tuesday, January 01, 2008 5:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 05, 2008 7:42 AM
Points: 1, Visits: 2

Hello,

How can I run the dbcc command?

Can it be done from the cmd prompt?

Sorry from my ignorance but I'm very new to SQL and any help would be appreciated.

Thanks!

Asher. :D

Post #437721

Jeff Moden

Posted Tuesday, January 01, 2008 8:40 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923, Visits: 26,811

Yes, but you need to do it through "OSQL". Lookup "OSQL" in Books Online for full details about usage.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #437737

george sibbald

Posted Wednesday, January 02, 2008 6:58 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:17 PM
Points: 5,270, Visits: 11,212

or use one of the SQL gui tools (Query analyser, enterprise manager. sql server management studio, maintenance plans). exact too, depends on version of SQL u r using.

Again see BOL

---------------------------------------------------------------------

Post #437958

« Prev Topic | Next Topic »

Permissions