Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005

    Unanswered: Procedure debugging in SQLSERVER

    Hi all,
    I wanted to ask...if there is someone who worked with pl/sql developer as well...then i wanted to know how can i TEST in the sql server like we do in the PL/SQL developer using the STEP IN we can test our procedure step by how can i do the same thing in sql server?????
    or generally also,if someone knows how can i execute a procedure without using the execute,that i can put values first by using like EXECUTE STORED PROCEDURE or anything n then watching it how is it going step by step????????
    thanks in advance...

  2. #2
    Join Date
    Sep 2005


    You can do it three ways:

    a) use SQL Profiler to trace the statements ....
    b) use SELECT/PRINT (insert into debug tables if you prefer)
    c) Use Transact SQL Debugger to trace (mostly application oriented)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts