locked
TYPES OF DBCC COMMANDS RRS feed

  • Question

  • Hi all How meny types of DBCC commands  in SQL SEVER 2005,Why we r using this commands ?Why we will this?

    Could  you please  reply this.
     

    Regards

    VASU
    Wednesday, March 17, 2010 6:12 AM

Answers

  • DBCC are database console commands and are categorised into 4 primary groups and there are several dbcc commands which are not documented and you will know those when you dig deep in to SQL server working principle and read a lot , blogs etc

    All four categories are documented here http://msdn.microsoft.com/en-us/library/ms188796.aspx 
    Thanks, Leks
    • Proposed as answer by TiborKMVP Wednesday, March 17, 2010 9:09 AM
    • Marked as answer by Vasavi Machina Thursday, March 18, 2010 4:06 AM
    Wednesday, March 17, 2010 8:14 AM
    Answerer

All replies

  • There is no usniveraslly accepted catrgorization of DBCC commands. The documented DBCC commands are documented in Books Online (transact-sql reference, DBCC). There are an unknown undocumented DBCC commands, which you might encounter as you work with SQL Server (like talk to MS support, read some article on the net, read some KB article, etc.).
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, March 17, 2010 6:33 AM
  • DBCC are database console commands and are categorised into 4 primary groups and there are several dbcc commands which are not documented and you will know those when you dig deep in to SQL server working principle and read a lot , blogs etc

    All four categories are documented here http://msdn.microsoft.com/en-us/library/ms188796.aspx 
    Thanks, Leks
    • Proposed as answer by TiborKMVP Wednesday, March 17, 2010 9:09 AM
    • Marked as answer by Vasavi Machina Thursday, March 18, 2010 4:06 AM
    Wednesday, March 17, 2010 8:14 AM
    Answerer
  • <<DBCC are database console commands and are categorised into 4 primary groups >>

    Wow, so there *is* an official (documented) catrgorization for DBCC commands nowadays. I guess you learn something new every day. :-)
    Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, March 17, 2010 9:09 AM
  • Hi Tibor  Karaszi,

    Thanks for your comment, Yes  your right   Iam  learing new things everyday and this is a great forum.





    Regards

    Vasukasturi
    Thursday, March 18, 2010 4:06 AM