开发者

Unable to step into stored procedure inside stored procedure - SQL debugging using VS2010 and SQL Server

开发者 https://www.devze.com 2023-01-11 06:26 出处:网络
I\'m checking out the SQL Debugger usi开发者_运维知识库ng Visual Studio 2010 (connecting to a SQL 2005 Enterprise Server), and I can successfully debug a stored procedure by going to Server Explorer -

I'm checking out the SQL Debugger usi开发者_运维知识库ng Visual Studio 2010 (connecting to a SQL 2005 Enterprise Server), and I can successfully debug a stored procedure by going to Server Explorer -> Right clicking on the procedure -> "Step Into Stored Procedure".

However, once I'm in, I can't step into or set any breakpoints inside any subsequent function or stored procedure calls. See the example below:

esp_StoredProc calls esp_AnotherStoredProc, but I can't set a breakpoint inside of esp_AnotherStoredProc or step into it during my debug session.

Is this a limitation of SQL debugging, or perhaps a limitation of my configuration or how I'm debugging things?

esp_StoredProc:

-- do something

-- do something else

-- call esp_AnotherStoredProc


I think that in sql server 2005 this was a limitation of SQL debugging. I could be wrong though.

0

精彩评论

暂无评论...
验证码 换一张
取 消