sql error log | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql error log

SQLErrorLog:Critical: EXECUTE permission denied on object ‘usp_fulfill_suppt_dat_bak’, database hil, owner ‘uid72593’. Error: 229, Severity: 14 this is the message from my foglight. i have no idea so can anyone tell me what do i do???
Login you are using doesn’t have the permission to execute usp_fulfill_suppt_dat_bak in the HIL database.
Make sure the login has the sufficient rights…
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

For a moment you can rely on foglight but entirely looking at the error message you should check on SQL server error log too for more information to resolve this issue. Look for Fixed Database roles in Books online for more information on permission and to resolve this issue. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.