CREATE PROCEDURE sp_dbcc_check_all_cat
AS
DECLARE cr_dbname CURSOR
	READ_ONLY
		FOR select name from sysdatabases

			DECLARE @dbname varchar(40)
				DECLARE @sql varchar(100)
					OPEN cr_dbname

						FETCH NEXT FROM cr_dbname INTO @dbname
					WHILE (@@fetch_status <> -1)
				BEGIN
			IF (@@fetch_status <> -2)
		BEGIN
	PRINT 'Starting CHECKDB on'+space(2)+@dbname
DBCC CHECKDB (@dbname)
	PRINT 'Ending CHECKDB on'+space(2)+@dbname

		PRINT 'Starting CHECKALLOC on'+space(2)+@dbname
			DBCC CHECKALLOC(@dbname)
				PRINT 'Ending CHECKALLOC on'+space(2)+@dbname

					PRINT 'Starting CHECKCATALOG on'+space(2)+@dbname
						DBCC CHECKCATALOG(@dbname)
					PRINT 'Ending CHECKCATALOG on'+space(2)+@dbname

				END
			FETCH NEXT FROM cr_dbname INTO @dbname
		END
	CLOSE cr_dbname
DEALLOCATE cr_dbname
	PRINT 'DBCC completed on the server'+SPACE(2)+@@servername

GO