SQL Server Performance

sql error log

Discussion in 'Getting Started' started by neo_143, Jun 29, 2007.

  1. neo_143 New Member

    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???
  2. MohammedU New Member

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


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    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.

Share This Page