disable debugging on production box...

• swjohnson

  Hall of Fame

  Points: 3254

  More actions

  March 4, 2003 at 5:32 pm

  #357715

  I am about to put a new SQL server into production but I noticed that when I attach to it in Query Analyzer I am able right click on a stored procedure and choose debug and it is able to debug. Is there any way I can prevent this on my production server? I don't want my developers or hackers to be able to debug on this production box.

  Thanks

  SJ

  

  ---

  Accepting all invites

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  March 4, 2003 at 6:48 pm

  #450289

  As I remember, During the client tools installation, you have options not to install debuger component. In your case, you may have to reinstall SQL Server.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  March 5, 2003 at 5:46 am

  #450312

  I think you could just put a deny on SP_SDIDEBUG.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Tmp

  SSCommitted

  Points: 1938

  More actions

  March 5, 2003 at 8:41 am

  #450318

  By default, SP_SDIDEBUG is granted for execute to public role. Revoke this permission...