OK, seems to be a side effect of using 'GROUP BY id with rollup' When I drop the rollup all the objects are found. odd???

SET NOCOUNT ON

select id,...

That doesn't sound right, I'm logged as the Administrator.