If you have ever come across a problem where the MSSQL host (eg windows) has crashed for some reason or another that you may have also come across the problem of having a possible issue with some of the databases coming corrupt where here is a way to run the dbcc check db command for all databases on an ms SQL instance.

EXEC sp_MSforeachdb @command1 = 'DBCC CHECKDB(?) WITH NO_INFOMSGS;
                PRINT ''Checked ? Status:'' + CONVERT(VARCHAR(255), @@ERROR)'

Example output is simple. Anything with a status which is no "0" should be investigated.

Checked master Status:0
Checked tempdb Status:0
Checked model Status:0
Checked msdb Status:0
Checked JEPS Status:0
Checked distribution Status:0
Checked Testing Status:0




Last Modified: 23 February 2017

Releated Posts


2012-08-07 - MSSQL - Finding the database restore history
2011-09-24 - MSSQL - Checking Uptime
2011-08-11 - MSSQL - Saving memory by using stored procedures
2011-08-09 - MSSQL - Last Backup time and size
2011-06-24 - MSSQL - Extracting part of an email address
2011-06-15 - MSSQL - Bulk Deleting rows with backup
2011-06-07 - MSSQL - DBCC Check All Databases
2011-06-03 - MSSQL - Who locks what
2011-05-26 - MSSQL - RandomString Function
2011-05-22 - MSSQL - Removing the aspnet membership database
2011-05-19 - MSSQL - ShrinkLog
2011-05-16 - MSSQL - Enum
2011-05-05 - MSSQL - Log Sizes
2011-03-01 - MSSQL - Kill connections by host
2011-02-23 - C Sharp / MSSQL Get inserted value of NEWSEQUENTIALID()
2011-02-22 - MSSQL - Kill connections by username
2011-02-20 - MSSQL - Unsigned int
2011-02-20 - MSSQL - All temp tables are global
2011-02-17 - MSSQL - Convert IP To big int
2011-02-05 - MSSQL - Levenshtein
2011-02-02 - MSSQL - Kill connections to a database
2011-02-01 - MSSQL - Convert unix timestamp to date time
2011-01-30 - MSSQL - RegEx Support
2011-01-30 - MSSQL - Adding MD5 checksum support
2011-01-30 - MSSQL - Adding SHASum support
2011-01-30 - MSSQL - Enabling CLR Functions
2011-01-29 - MSSQL - TRIM Function