Nested Stored procedure: Indicate scope/which sproc the variables belong in the Variables and Watchers Tab
In debug mode, in case you have a nested stored procedure, while stepping into nested stored procedure calls the debug variables display window shows a list of all variables that have been created thus far through the entire debug session, not just the ones for the current stored procedure.
There is currently no way to identify the scope of the variables in the "variables" view to indicate which stored procedure the variable applies to. This is a new enhancement request to display the the current context of variables list.
There is no information available in the variables display window to indicate which one of these I should be adding to the watch list to capture the currently scoped operations. (Also, it is not uncommon to be operating with up to 100 variables and/or parameters within any one stored procedure. Once you are 2 or 3 nesting levels down then this rapidly becomes completely unmanageable.)
Solution: Can you add a new column in Variables and Watchers Tab which indicates the name of the stored procedure the variable belongs to?
Issue #13329 |
New |
Completion |
No due date |
No fixed build |
No time estimate |