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: