sql solace
Thursday, 30 November 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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment