>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 ?

In the Query Analyzer Object Browser navigate to the stored procedure, right-click on it and select Debug.