MS SQL Server Debugger (Revision #23)

The latest version of Aqua Data Studio 7.0 comes with the Microsoft SQL Server Debugger designed to help with testing and debugging SQL Procedures and Functions.

MS SQL Debugger	MS SQL Server Registration Advanced Properties

New Features in the Debugger

• Break points Tab – You can now set break points at any line in the Procedure or Function source code in order to run it up to this line.
• Variables Tab – You can enter variables and view their values during the debugging in this tab.
• Watches Tab – You can enter expressions and watch their values in this tab.
• "Step Into" button allows you to step into the next block of code.
• "Step Return" button allows you to step to the next return of code.
• "Step Over" button allows you to move to the next line of the code.
• Stop Button – You can stop the debugger at any time.
• Console Tab – Outputs is displayed here.

Configuring DCOM security on SQL Server for Aqua Data Studio debugger:

In case granting "administrators" permission is a concern, then :-

• You can create a local user under "Users" group.
• Then go to Control Panel > Administrative Tools > Local Security Policy > Security Settings > Local Policies > Security Options :-
  • Double-click "DCOM: Machine Access Restrictions" policy, click Edit Security, add the user created above, allow "Remote Access"
  • Double-click "DCOM: Machine Launch Restrictions" policy, click Edit Security, add the user created above, allow "Local Launch", "Remote Launch", "Local Activation", "Remote Activation"
  • Double-click "Network Access: Sharing and Security Model for local accounts" policy, and set to Classic"
• Go to Control Panel > Administrative Tools > Component Services > Computers > right-click My Computer > click Properties > click COM Security tab :-
  • In Access Permissions section, click Edit Default > add the user created above, allow "Remote Access"
  • In Launch and Activation Permissions section > click Edit Default > add the user created above, allow "Local Launch", "Remote Launch", "Local Activation", "Remote Activation"

(The Component Services section, to be more accurate, you can go to a specific component, and grant permission from there, instead of from "My Computer", which is a blanket grant)

 

Documentation -> MS SQL Debugger