Post reply

sp_sdidebug extended stored procedure

  • June 25, 2004 at 10:42 am

    #88149

    Hello listers,

    Many developers here are actually getting this error when they are debugging (with the microsoft developpement environnement) our application (written in c++):

    EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

    Since there is no stored procedures called but only calls to the Database using DB-Library, I don't understand how this procedure could be called.

    If anyone have answer for me, it would be very appreciated.

    Best regards,

    Carl

  • June 25, 2004 at 7:02 pm

    #512067

    If by any chance somebody applied sp3 or later to your server then you should re enable the exec permisions  on the procedure. for more info read this article:

    http://www.dbazine.com/cook1.shtml

    HTH

     

     

     


    * Noel

  • June 28, 2004 at 7:14 am

    #512160

    Hello Noel,

    Thank's for your answer.

    I applied sp3a on my server (not on client side). Also I grant execute on this proc to public but the error still arise.

    But my question was not exactly this. My question is : Why this "stored proc" (sp_sdidebug) is called when our application is debugged when there is no Transact-SQL involved? Is the T-SQL Debugger launched automatically?

    Best Regards,

    Carl

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

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