Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Step through a stored procedure or inspect cursor result
Message
 
À
08/09/2005 16:45:23
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01047868
Message ID:
01047870
Vues:
18
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform