You are going to just love this one! Try it like this:exec dbo.sp_msforeachtable 'select * from ?'

Note the lack of brackets. Go figure.