There is an undocumented stored procedure that you can use to run a single command on all tables in a database. It is very useful when doing routine jobs on all the tables. For example, re-indexing the tables would be done like this:
sp_MSforeachtable [@command1 =] 'sql_command'
[, [@replacechar =] 'replacement_character']
[, [@command2 =] 'sql_command']
[, [@command3 =] 'sql_command']
[, [@whereand =] 'sql_command']
[, [@precommand =] 'sql_command']
[, [@postcommand =] 'sql_command']
sp_Msforeachtable "DBCC DBREINDEX ('?')",
@precommand = 'print ''Indexing ...''',
@postcommand = 'print ''Completed ...'''
Enjoy and use this with care. It will do any command on all the tables.