Use sp_MSForEachDB instead of your own loop

sp_msforeachdb 'select ''?'' as DBName, count(*) as ObjectCount from ?.sys.objects'

sp_msforeachtable 'select ''?'', count(*) from?'

sp_msforeachtable 'update statistics ?'

posted @ 2013-02-19 14:37  AOT  阅读(118)  评论(0编辑  收藏  举报