How to use DBCC HELP

Memorizing DBCC commands (or any command for that matter) can be difficult if you don’t use it often. Thank goodness for the folks at Microsoft for creating the DBCC HELP command. Below is a quick way to use DBCC HELP to figure out any command (with syntax) that might have slipped your mind.

First, run DBCC HELP(‘?’) to display a list of available DBCC commands (see image below).

DBCC HELP RESULTS

Second, replace the ‘?’ with whatever DBCC command you want help on. For example, let’s use “checkdb.” Once you run DBCC HELP(checkdb) you get a printout of the CHECKDB syntax. (see image below)

DBCC HELP CHECKDB RESULTS

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.