Binaryworld - Check integrity of all tables ... [ SQL Server -> Stored Procedure ]

/*
This stored procedure can be used to check the integrity of the data
and index pages for all user tables in the particular database.
In comparison with DBCC CHECKDB statement, this stored procedure
takes less time to run, because only user tables will be checked.
You can pass the database name into CheckAllTables stored procedure,
as in the example below (if the database name was not specified, the
current database will be used):

EXEC CheckAllTables 'pubs'
*/

IF OBJECT_ID('CheckAllTables') IS NOT NULL DROP PROC CheckAllTables
GO

CREATE PROCEDURE CheckAllTables (
@dbname sysname = null
)
AS
DECLARE @execstr nvarchar(255)
SET NOCOUNT ON
IF @dbname IS NULL SELECT @dbname = DB_NAME()
SELECT @execstr = 'EXEC ' + @dbname + '..sp_MSforeachtable @command1="print ''?'' DBCC CHECKTABLE (''?'')"'
EXEC(@execstr)
GO