Pages

Wednesday, September 11, 2013

SQL SERVER – Check Database Integrity for All Databases of Server | Journey to SQL Authority with Pinal Dave

Today we will see quick script which will check integrity of all the database of SQL Server. EXEC sp_msforeachdb 'DBCC CHECKDB(''?'')' Above script will return you lots of messages in resultset. If there are any errors in resultset they will be displayed in red text. If everything is black text there is no error. Typical output… Continue Reading...

Source: SQL SERVER – Check Database Integrity for All Databases of Server | Journey to SQL Authority with Pinal Dave