Thanks noeld,

The following works great:

insert into Admin.dbo.contigInfo

exec sp_MSforeachdb 'use ? dbcc showcontig with tableresults, all_indexes'

Makes for an elegant solution.

I'm aware of multi RS returned. I'm also working on...

Thanks Phil. That worked for the cursor. Any idea why sp_MSforeachdb only reports on one database?

Not much other than failure error as shown below. I won't be back in my office til Monday so I'm not being rude by not replying... I really do...

Thanks for your input. I didn't want to bog down with details, but differential is to different device every other day (MWF, TT), so remote copy has previous day....

Thanks for the links. I failed to mention that I'm running this straight from EM - no homegrown application interface code such as VB involved. I looked in...

Read the article 'Inside Sql Server Maintenance Plans'

at

http://www.sql-server-performance.com/ak_inside_sql_server_maintenance_plans.asp