Home Forums SQL Server 2005 Administering Help ! Can't login, SELECT permission denied ....... RE: Help ! Can't login, SELECT permission denied .......
Robert-378556
SSCertifiable
Points: 5917
More actions
June 17, 2008 at 6:33 am
#829705
Why not sys.configurations?
Proper qualifier would be database.schema.objectname.
Run dbcc checkdb. If ok, check the log file, if someone dropped permissions. "public" must have select permission on this system view.