modify codes while debuging

  • Is there a way in the T-debugger which I can modify the stores procedures I am debugging and re-start the same debug? The only way to modify stored procedures I found in SQL Server is from EM which is not very logical and efficient place. any idea?

  • You can copy the code from EM and paste in QA then change CREATE PROCEDURE to ALTER PROCEDURE, make your changes and execute (note: make sure you are in the correct database). But as for the rest this is still a new area to SQL Server itself and not sure what effect will occurr since I haven't had a chance to play directly.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

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