Debugging stored procedure in visual studio?

  • Thread starter Thread starter bredal Jensen
  • Start date Start date
B

bredal Jensen

I have a stored procedure wich is inoked through my asp.net code.

The stored procedure failed and it quit extensive.

I 'm therefore wondering if there is a way to step through the stored
procedure
from visual studio.net or maybe from sql server 200 itself?


Thanks in advance
 
I just used "print 'line 5 executed'" kind of messages between some lines.
so I can get an idea, where it is failing...

OR if u used try.. catch.. for the calling code segment, u'll get the
descriptive message from the error.

regards,
CMA
 
Back
Top