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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Visual studio 2005 corrupt MS SQL 2000 stored procedures 2
Weird situation - Stored procedure executed twice 2
Problem retrieving data from Stored Procedure from SQL 2005 2
What are the steps to fix damaged MDF files in SQL Server? 0
How to call multiple stored procedures in one db trip? 2
schedule sql server stored procedures defined in a table?? 1
clr stored procedure 2

Back
Top