Post reply

EXECUTE permission denied (Stored procedure debugging)

  • June 15, 2004 at 9:43 am

    #85760

    Guys I am getting this error when I try to debug a stored procedure using Query Analyzer:

    Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1[Microsoft][ODBC  SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

    I only get this error whe I run Query analyzer from my PC, when I log onto the server itself everything works fine. I have administrative for everything on my network.

    Help please. thanks.

  • June 15, 2004 at 9:54 am

    #510491

    It sounds like you are not using exactly the same username that your using on the server.  For instance, you might be using sa on the server and windows authentication on the machine thats not letting you run your stored procedure.

    Just want to cover the basics:

    Double check the username you are using on your PC, and make sure in enterprise manager that you have given yourself execute permissions on the stored procedure.

     

  • June 15, 2004 at 11:12 am

    #510502

    I do have the same username. I have 40+ stored procedures and each one has my username with full rights.

  • June 15, 2004 at 11:24 am

    #510504

    actualy i dont get that error anymore but all the buttons are disabled when i try to debbug.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply