Post reply

SSMS2008 Debug Sysadmin Permissions

  • October 7, 2014 at 7:10 pm

    #291311

    Is it just me or does anyone find the sysadmin privileges to debug in SSMS2008 crazy?

    Alot of companies tend to hire a handful of DBAs and a whole bunch of developers. The developers tend to build their apps and writes the stored procedures / functions. Does this means we're supposed to grant all developers sysadmin to all development boxes?

    Anyone has a workaround? Perhaps granting sp_enable_sql_debug or some other method?

    Thanks.

  • October 8, 2014 at 2:12 am

    #1750854

    SSMS debugger, a product which contains more bugs than it will ever help to find.

    I doubt most people use it because of the problems with it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 8, 2014 at 5:50 am

    #1750901

    The very first time I tried the SQL debugger, it took the SQL Server offline for a few moments. I have no idea what happened or why, but I've not used it since then. Too buggy and not needed anyway.

    And no, you should not grant sysadmin privs to all the developers.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 8, 2014 at 8:58 am

    #1751012

    What are your recommendations as far as debugging stored procedures / functions without SSMS?

    Thanks.

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

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