Debugging Stored Procedure does not seem towork

• Brandon Haight

  Grasshopper

  Points: 24

  More actions

  August 15, 2005 at 11:05 am

  #363462

  I am trying to debug a stored prodedure and when I click on debug in the Query Analyzer and hit Execute, the stored procedure executes without allowing me to step through the procedure.

  Is there a setting of some sort that I am missing or need to set?

  Thanks,

  Brandon

• Bernard Omiple

  SSC Veteran

  Points: 278

  More actions

  August 15, 2005 at 10:10 pm

  #582332

  Hi Brandon:

  Make sure you are running the SQL server service using a domain account, and not the local system account.

  HTH