I want to step through a stored procedure, I'm using the guidelines in this Microsoft article. http://support.microsoft.com/kb/316549
Every time I right click a stored procedure and select "Step Into Stored Procedure" I get the error message "Canceled by user." in the output pane.
Visual Studios will open a stored procedure, and it will also execute a stored procedure.
When I add a break point to an open stored procedure in Visual Studio it crashes Visual Studio.
I am using Visual Studio 2010 SP1, and SQL Server 2008 R2.
Thank you for your question, we're doing research on this case, it might take some time before we get back to you.
Eric Yang [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.