m.ciesiensky (1/6/2010)

---

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]'.


Any help from anyone will be much appreciated.

exec sp_msforeachtable 'select * from ?'

exec sp_msforeachtable 'select * from CBL.?'