Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Debugging does not show current stored procedure version

Tags:

I'm working on a SQL Server 2008 R2 instance. I've just changed the code for a stored procedure. When I try to debug that proc, the SSMS debug window shows the older version of the code.

What can I do in order to force SSMS into presenting the current version of the code?

Thanks in advance.

like image 472
rsenna Avatar asked Jan 22 '12 14:01

rsenna


People also ask

How do I debug a stored procedure?

To debugging SP, go to database->Programmability->Stored Procedures-> right click the procedure you want to debug->select Debug Procedure.


1 Answers

This problem has existed for years in SQL Server. It usually takes a couple time starting and stopping the debugger before it syncs up with the correct version of the source.

You will also notice that a few windows are open showing the last source the debugger is aware of. They need to be closed. Even though it is a pita, the fastest way to clear the problem is to stop management studio and restart it.

like image 154
old head Avatar answered Sep 17 '22 14:09

old head