It sounds like access rigths issue. Are you using the same login to SQL Server all the time?

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