Cool Maintenance T-SQL Scripts

How to run an integrity check on all databases

DECLARE @SQL VARCHAR(1000) 
DECLARE @DB sysname
DECLARE curDB CURSOR FORWARD_ONLY STATIC FOR 

 SELECT [name] 
 FROM master..sysdatabases 
 WHERE [name] NOT IN ('tempdb') 
 and DATABASEPROPERTYEX(name, 'Status') != 'OFFLINE'
 ORDER BY [name] 
 
OPEN curDB 
FETCH NEXT FROM curDB INTO @DB 
WHILE @@FETCH_STATUS = 0 
 BEGIN 
 SELECT @SQL = 'USE [' + @DB +']' + CHAR(13) + 'DBCC CHECKDB WITH NO_INFOMSGS' 
+ CHAR(13) 
 --EXEC(@SQL) -- Uncomment to execute the command
 PRINT @SQL -- Prints just the command, comment if you do not need the command 
 FETCH NEXT FROM curDB INTO @DB 
 END 
CLOSE curDB 
DEALLOCATE curDB