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