Calling debugger from SSMS

I realize that the DEBUG capability has been removed from SSMS and moved to the IDe for Visual Studio. As much as that annoys me , I am dealing with it.

Is there a way I can open a SP into the debugger from SSMS? I very much miss the ability to right click a SP in my list of 300 and choose form edit, run or debug. I dont care if hte debugger is a separate app, can't I have SSMS send my proc to the visual studio debugger?

Currently I have to open the VS app separately, and then establish connection, and the re-fnd my proc in that very long list of 300 that is in there.

Sorry, you need to use Visual Studio to debug stored procedures in SQL Server.|||

I know that.

The question more specifically is:

Is there a way to link the SSMS annd hte visual studio together such that I can tell visual studio to debug a SP I am pointing to in the SSMS?

I want to be able to right click a Sproc in SSMS, select "Step Into" and have the Visual studio open on its own with the correct SP in debug mode.

|||No this is not possible.|||

Hi,

I tried to configure t-sql debugger in my visual studio 2005. I have sql server 2005. I somehow unable to debug the stored procedure thru my server explorer in VS 2005. I can put a breakpt, but never be able to hit the brk point kept in stored procedure.

Please help me out to start t-sql debugging in my vs 2005.

Thanks,

Anni