Thursday, November 30, 2006

sp_MSforeachdb (Undocumented Stored Procedure)

Loops though all databases, repeating the specified command on each one.

The question mark represents the database name, for example ;

EXEC sp_MSforeachdb @command1='print ''?'' DBCC CHECKDB (''?'') '

No comments: