SQL Server - sp_MSforeachtable

This is an undocumented stored procedure. It's found in the master db and accepts the following input parameters.It returns one (or greater ) rows for every table. Each table has it's own resultset .

I find it useful for managing a process such as a sql server rapid tuning for an emergency performance issue

--Input parameters :

@command1 nvarchar(2000),
@replacechar nchar(1) = N'?',
@command2 nvarchar(2000) = null,
@command3 nvarchar(2000) = null, 
@whereand nvarchar(2000) = null,
@precommand nvarchar(2000) = null, 
@postcommand nvarchar(2000) = null


--An example:

exec sp_MSforeachtable 
 @command1 = 'print ''Processing table ?''',
 @command2 = 'UPDATE STATISTICS ? WITH FULLSCAN' ,
 @command3 = 'print ''Processed table ?'''