Debugging Stored Procedure Question

• Ronnie Jones

  Hall of Fame

  Points: 3377

  More actions

  December 21, 2004 at 9:41 am

  #85032

  Hello All,

  Has anyone ever seen the following SQL 2k message regarding debugging a stored procedure:

   

  "Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permissions to execute master.sp_sdidebug. Run SQL server setup or contact database administrator."

  The user has SA rights on the server. If anyone knows how to resolve this error, please let me know.

  Thanks.

  Ronnie

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  December 21, 2004 at 11:18 am

  #534651

  Check this out.

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;836734