SSMS 2012 - Debugger fails to navigate through dynamic SQL query and step by step from there.

SSMS 2012 - Debugger fails to navigate through dynamic SQL query and step by step from there. by Maurice Pelchat

Closed

Type:	Bug
ID:	776807
Opened:	1/17/2013 9:02:38 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

SSMS 2012 T-SQL Debugger doesn't handle correctly dynamic SQL debugging which SSMS2008 was doing fine.

When the debugger reach the Exec statement, a windows for Dynamic SQL displays but with no code visible (first bug) and trying to do F11 displays an error message (second bug).

There is no way to continue debugging without closing the windows and doing F11 again.

Details (expand)

French

SQL Server 2012 - Developer Edition

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows 7 Professional

French

-- create this proc.
create proc demoDebuggerBug
as
Begin
Exec('Select ''this is a dynamic query'' ')
End
go
--run this statement in debug mode with stepinto (F11)
Exec demoDebuggerBug

When the debugger reach the Exec statement, a windows for Dynamic SQL displays but with no code (first bug) and trying to do F11 displays an error message (second bug).

There is no way to continue debugging without closing the windows and doing F11 again.

The dynamic code should be displayed as it was the code with SSMS2008 and it should be possible to step-it through as it was before.

X64

0 attachments

Posted by Microsoft on 4/8/2013 at 10:50 AM

Hello Maurice. This issue is being tracked in a different connect item. Please look for updates here: http://connect.microsoft.com/SQLServer/feedback/details/736509/sql-server-2012-rtm-management-studio-cannot-debug-sp-executesql Please let us know if you have any questions. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)

Posted by Microsoft on 2/21/2013 at 1:54 PM

Hello Maurice. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)

Posted by Maurice Pelchat on 1/17/2013 at 9:09 AM

It is apparent that SSMS 2012 is a big rewrite, but Microsoft should give more priority in correcting bugs introduced in this rewrite.

I have submitted many annoyances introduces by this version like the one related to selecting through shortcuts the database context. The combo box previous behavior is completely broken, and since this is a feature constantly used by DBA this a MAJOR ANNOYANCE. I have received no feedback since and there are MANY MONTHS since I submitted it. Even if I use a french version, I'm pretty sure that these bugs exists in all languages. They should AT LEAST TRY IN ENGLISH VERSION and give a feedback.