SQL Server DBCC Commands

SQL Server DBCC Commands

SQL Server DBCC Commands
 
Database Consistency Checker (DBCC) statements are database console commands and used for server monitor and maintenance.
 
Following are some DBCC commands are:
 
  • DBCC INPUTBUFFER(SP_ID): Shows the last statement executed for a particular SPID. This statement is mostly used for troubleshooting purposes to determine the exact command a particular SPID is running.
  • DBCC CHECKCONSTRAINTS(Table_Name): Shows all available check constraints in current database.
  • DBCC SHRINKFILE (File,Percentage): Used to shrink database file.
  • DBCC HELP(Command): Returns syntax information for the specified command. EX: DBCC HELP(CHECKDB).
  • DBCC CHECKALLOC
  • DBCC OPENTRAN
I am still working for listing all the available DBCC Commands in this post.
0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share