Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Step through a stored procedure or inspect cursor result
Message
 
To
08/09/2005 16:45:23
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01047868
Message ID:
01047870
Views:
19
Paul,

If you have Visual Studio 2003 (or 2005 I suspect, but haven't checked) you can use the Server Explorer to navigate to the SQL Server and into the database and to the Store Procedures. You can edit the Stored Procedure in question. While editing it, you have the option of stepping into it.

HTH,
Chad

>I am running some complex stored procedures that select from multiple cursors and eventually populate a local table. Is there any way that I can step through the creation of each cursor so that I can inspect the cursor data that is returned in each cursor before it populates my local table ?
>
>Thanks For Your Help !
>Stephen J. Hunt
>Admit Computer Services Inc.
_________________________________
There are 2 types of people in the world:
    Those who need closure
Previous
Reply
Map
View

Click here to load this message in the networking platform