>>You have no sp_MsForEachTable no INFORMATION_SCHEMA.Tables?
>>There is something wrong with installation then.
>>This is View with is created for each Database
>>Could you post your test script?
>>That View EXISTS in ALL versions since SQL Server 2000
>>
>>
>>What is the result of SELECT * FROM sys.Tables (this is another view but it is in SQL Server 2005 only, I think)?
>
>I have:
>
>"Invalid object name 'sys.Tables'.
>
>Yes, the sp_MsForEachTable was working for a while but stopped since today. All the rest in regards to that is also no longer available.
Looks like somehow you don't see (or don't have rights) to the Master database. Insteresting, how and why can it be? Do you have full backup of all your databases?
If it's not broken, fix it until it is.
My Blog