Debugging SQL Server 2000 from VS 2005

[Brent]

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

 

[Brent]

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]

Ok that doesn't help. I guess its when you have the query open in VS but you
still have to open server explorer which takes forever with lots of stored
procs.