debugging a stored procedure

  •  

    Hi,

    Can any one help me how to debug a stored procedure, i went to query analyzer and i right clikced on STORED PROCEDure i selected debug option also but it is not giving any error when i kept he break poing on any line it is not stopping stored procedure is executing.

     

  • Try executing this:

    sp_sdidebug 'legacy_on'

    in Query Analizer in the same database you are debugging..

  • Aswani - do you first get a warning box saying that "..Debugging may not work properly if you log on as 'Local System Account'..." ?!?!

    If you do, then you have to use an actual user account...(EM - properties - security)







    **ASCII stupid question, get a stupid ANSI !!!**

  • iam doing from sql query analyzer i didnt get any warning  message , i logged as a administrator...in my system i have only client,,,,

     server is in other place.

  • ok - then have you tried Tyson's suggestion ?!?!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 5 posts - 1 through 4 (of 4 total)

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