Debugging stored procedures

  • One of the developer is trying to debug stored procedure on visual studio. He is getting master.dbo.enable.sql error. I tried to google this but one of the link said that I needed to give sysadmin permissions inorder to allow him debug. If any one could tell me the procedure for securing debug process for stored procedures, it would lot of help. If you could be more detailed , it wil be helpful... Thanks in advance..

  • I believe you can grant EXECUTE rights against the sp_sdidebug stored procedure. It'll be in the master database, meaning you'll have to grant the user access to the master database. This should prevent having to give out sysadmin rights.

    K. Brian Kelley
    @kbriankelley

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

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