MS SQL Server Debugger (Revision #27)

The ability to debug SQL Stored Procedures is a vital requirement for any enterpirse environment.  We have continued our enterprise support by extending the debugger to support MS SQL Server 2005/2008.  The new debugger provides the only manner of debugging MS SQL Server Stored Procedures from non-Windows platforms.  The debugger follows the same user interface  as our previous debuggers for Oracle and Sybase to privide a common debugger accross all databases.

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"

(You can also go to a specific component in the Component Services section to grant permission, instead of granting permission from "My Computer" which is a blanket grant)

 

Documentation -> MS SQL Debugger