This tells of 2 sp's in mssql that let you run sql commands against each table or db in a server.
http://www.databasejournal.com/feat...hp/3441031

The following works great for me to run against all the databases on a specific server.
[sql]
declare @cmd1 varchar(500)
declare @cmd3 varchar(500)
set @cmd1 =
'if ''?'' <> ''tempdb'' print ''*** Processing DB ? ***'''
set @cmd3 = 'if ''?'' <> ''tempdb'' dbcc checkdb(?)'
exec sp_MSforeachdb @command1=@cmd1,
@command3=@cmd3
[/sql]