i have a huge stored procedure abt 500 lines..and i am calling this sp from an asp.net page...thn i got this error - error converting varchar to numeric - and am trying to debug...is there any way we can find out where the error is coming from...like aproxly which line number..etcor do i have to go through each line manually and see where i am doing the conversion...
thanksNever tried it myself but it should let you step through a sproc like you would your C#/VB.Net code behind.
Walkthrough: Debugging Hello World, a SQL Stored Procedure|||hi MMS
I was able to isolate the line tht was causing the problem..however i will go through the article to see if it will help with some info for future use.
thanks.
No comments:
Post a Comment