Microsoft SQL Server provides a set of commands that will help you, called the DBCC commands. Originally that stood for Database Consistency Check commands, but they’ve been expanded since then to do a bit more. The DBCC commands are divided into four main categories:
1. Status commands
2. Validation commands
3. Maintenance commands
4. Miscellaneous commands.
Let’s take a look at a few of the more common ones.
1. Status commands
2. Validation commands
3. Maintenance commands
4. Miscellaneous commands.
Let’s take a look at a few of the more common ones.
