Question about CHECKCATALOG.

Hello,
Is there a parameter that can be used with CHECKCATALOG so
that it checks every database on the server, or does it
have to be run separately for each database.
Also, is this one of those routines that should be
regularly run for best practice purposes?
Thanks.
-LThe command cannot by itself run over several databases. You can write a
cursor to loop the databases, or use the undocumented (at own risk)
sp_MSforeachdb procedure (which loops in a cursor for you), search the net
for usage details.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Loudoun" <lemswiler@.rhcc.com> wrote in message
news:098d01c3aa18$a83ef0a0$a001280a@.phx.gbl...
> Hello,
> Is there a parameter that can be used with CHECKCATALOG so
> that it checks every database on the server, or does it
> have to be run separately for each database.
> Also, is this one of those routines that should be
> regularly run for best practice purposes?
> Thanks.
> -L