Home Library Learn Samples Downloads Support Community Forums
1 out of 1 rated this helpful - Rate this topic

DBCC HELP (Transact-SQL)

SQL Server 2008

Returns syntax information for the specified DBCC command.

Topic link iconTransact-SQL Syntax Conventions

Copy 

DBCC HELP ('dbcc_statement' | @dbcc_statement_var | '?')
[ WITH NO_INFOMSGS ]
dbcc_statement | @dbcc_statement_var

Is the name of the DBCC command for which to receive syntax information. Provide only the part of the DBCC command that follows DBCC, for example, CHECKDB instead of DBCC CHECKDB.

?

Returns all DBCC commands for which Help is available.

WITH NO_INFOMSGS

Suppresses all informational messages that have severity levels from 0 through 10.

DBCC HELP returns a result set displaying the syntax for the specified DBCC command.

Requires membership in the sysadmin fixed server role.

A. Using DBCC HELP with a variable

The following example returns syntax information for DBCC CHECKDB.

SQL
Copy 
DECLARE @dbcc_stmt sysname;
SET @dbcc_stmt = 'CHECKDB';
DBCC HELP (@dbcc_stmt);
GO

B. Using DBCC HELP with the ? option

The following example returns all DBCC statements for which Help is available.

SQL
Copy 
DBCC HELP ('?');
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.