Post reply

Debugging sql 2005 stored procedures with Visual Studio 2005

  • February 21, 2008 at 8:04 am

    #378681

    I'm trying to debug SQL Server 2005 stored procedures with Visual Studio 2005. According to Microsoft specifications the user of the connection has to be sysadmin. Doing this the debug works correctly, but I want to debug without have administration permissions or without be sysadmin. Is it possible? Have any way to do this?

    Thanks

  • March 12, 2008 at 9:01 am

    #788630

    Go into the master database, and give your user execution rights to sp_enable_sql_debug.

  • March 12, 2008 at 9:11 am

    #788636

    Thanks for the response, but I tried to do this and It can't work. I obtained the same error message.

  • March 14, 2008 at 4:54 am

    #789533

    Also give the user to sys schema , user will need execute permission.

  • January 9, 2009 at 8:38 am

    #924248

    Did this ever work? I'm in the same situation now

  • January 9, 2009 at 8:54 am

    #924271

    I'm not sure if this works without being sysadmin. You might be able to kludge it, but after all that, why not just give sysadmin? This should only be on dev systems and you can handle issues outside of SQL Server.

  • January 9, 2009 at 9:04 am

    #924284

    Your right in what your saying but as always managers are asking that i reduce the number of users with sysadmin access .... thanks for the reponse I've seen a couple other posts on the web about this approach and they all seem to indicate that it doesn't work.

    My argument to microsoft would be a developer needs to debug but the DBA doesn't need them to have all the other rights associated with sysadmin ....

    I think i'll just end up granting Sysadmin rights on demand then removing them once the developer is finished debugging it isn't used that often anyway so....

Viewing 7 posts - 1 through 6 (of 6 total)

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