Re: Debugging SQL Server 2000 from VS 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ok according to MSDN:
To debug a stored procedure in the text editor

a.. In a source window, right-click the stored procedure and choose Step
Into Stored Procedure from the shortcut menu.
But i don't see any shortcut from the rightclick menu that says "Stop into
stored procedure". How would it know its a stored procedure anyways...imean
the stored procedure is just a string name that your passying in.


"Brent" <brentwa@xxxxxxxxxxxxxxxx> wrote in message
news:%23LNk9EA3GHA.3944@xxxxxxxxxxxxxxxxxxxxxxx
I asked this question in SqlServer.programming and it was never answered. I
am hoping someone here can help me out.

Hi i have a pretty basic question. We just enabled debugging on some of
our
development SQL Servers. Most of our servers have over 5000 stored
procedures and trying to go to VS Studios server explorer and open up the
stored procedure takes forever. Is there another way to set set a break
point in a stored procedure so it will stop other than through visual
studios server explorer?

thanks,
Brent




.

Relevant Pages

  • Debugging SQL Server 2000 from VS 2005
    ... Hi i have a pretty basic question. ... procedures and trying to go to VS Studios server explorer and open up the ... Is there another way to set set a break ... point in a stored procedure so it will stop other than through visual ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is there a way to view Stored Procedure, Trigger andFunction Usage in SQL Server?
    ... Now add sysobjects to get the name of the stored procedure where your ... create a stored procedure in the master database add a shortcut ... Triggers, Stored Procedures and User Defined Functions. ... called by one of the other SP's or triggers in the database (there are ...
    (comp.databases.ms-sqlserver)
  • Re: Debugging SQL Server 2000 from VS 2005
    ... still have to open server explorer which takes forever with lots of stored ... right-click the stored procedure and choose Step ... stored procedure takes forever. ... Is there another way to set set a break ...
    (microsoft.public.dotnet.framework.adonet)
  • VS.Net - Opening SQLS2k Stored Procedures in the IDE
    ... Double-click the name of the stored procedure you want to open. ... When I Right-click the name of the stored procedure the shortcut menu ... When I drag the stored procedure into the work area it gives me that ... Other related functionality; i.e. Creation of Stored procedures is ...
    (microsoft.public.dotnet.general)