Timothy,

when attempting to run sp_msforeachtable in each of the variations below, I get these errors. I have tried running from both the master and CBL databases, with all same results.

Any Ideas?

exec dbo.sp_msforeachtable 'select * from CBL.dbo.[?]'

Msg 208, Level 16, State 1, Line 1

Invalid object name 'CBL.dbo.[dbo].[ae_amap]'.

exec dbo.sp_msforeachtable 'select * from CBL.[?]'

Msg 208, Level 16, State 1, Line 1

Invalid object name 'CBL.[dbo].[ae_amap]'.

exec dbo.sp_msforeachtable 'select * from [?]'

Msg 208, Level 16, State 1, Line 1

Invalid object name '[dbo].[ae_amap]'.

exec dbo.sp_msforeachtable 'select * from [CBL].dbo.[?]'

Msg 208, Level 16, State 1, Line 1

Invalid object name 'CBL.dbo.[dbo].[ae_amap]'.

exec dbo.sp_msforeachtable 'select * from [CBL].[dbo].[?]'

Msg 208, Level 16, State 1, Line 1

Invalid object name 'CBL.dbo.[dbo].[ae_amap]'.

Any help from anyone will be much appreciated.