Warning: Fatal error occurred at sep 20 2022 at 4:18am. Note the error and time, and contact your system administrator. A severe error occurred on current command. The results, if any, should be discarded. (Microsoft SQL Server, error: 21)
The above is the error I get when I try to access the tables of a particular database while logged in as user "pps2". Meanwhile I can assess this same database tables when I'm logged in as sa.
In the error log, I see the following:
Error: 211, Severity: 23, state: 51 Possible schema corruption. Run dbcc checkcatalog.
I have run the checkcatalog and still same issue persist.