New Features - Version 7.0
Introduction
Entity-Relationship Modeler
Debugger Support
    MS SQL Server Debugger
    DB2 for LUW Debugger
New DBA Tools
    DB2 for LUW DBA Tools
    MySQL DBA Tools
Charts Toolkit for Grids & Pivot Grids
Enhanced Visual Editing
    Multiple Selection Scripting
    Quick Filtering and Sorting
    Table Visual Editor
New Database Vendors and Versions
    Apache Derby
    DB2 for iSeries
International Localization
Application-level Enhancements
    Pivot Grid Enhancements
    Windows Launcher
    Logging Enhancements
    Server Registration Enhancements
Smarter SQL, HTML, XML & Text Editors
Enhanced Tools
    Schema Script Generator
    Server Script Generator
    Object Search
    Table Data Editor
    Query Builder
    ER Diagram Generator
    Explain White Board
Redesigned Compare Tools
    Schema Compare
    Directory Compare
Version Control

MS SQL Server Debugger

Aqua Data Studio 7 expands enterprise support with the ability to debug SQL Stored Procedures in Microsoft SQL Server 2005/2008. The new debugger provides the same consistent user interface you have come to know with our Oracle and Sybase debuggers. This allows you to use a common debugger across all the databases you interact with, and in fact offers the only way to debug MS SQL Server Stored Procedures when running on non-Windows platforms.

MS SQL Debugger MS SQL Server Registration Properties for the new MS SQL Debugger
MS SQL Debugger MS SQL Server Registration
Advanced Properties

New Features in the Debugger

  • Supports Microsoft SQL Server 2005/2008.
  • Breakpoints Tab – Set breakpoints at any line in the Procedure or Function source code to run just the section of the code you are testing.
  • Variables Tab – Enter variables and monitor their values during debugging.
  • Watches Tab – Enter expressions and watch their values in this tab.
  • Console Tab – All outputs are displayed here.
  • Step Into to move to the next block of code.
  • Step Return to move to the next return of code.
  • Step Over to move to the next line of code.
  • Stop button to halt the debugger at any time.

Documentation -> MS SQL Debugger

 

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"
  • Disable Windows Firewall or any other Firewall software that would prevent DCOM clients from connecting to the DCOM server.

  • (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)

 

The MS SQL Server debugger uses the Open Source Library j-Interop to communicate with Windows COM to make the debugger possible.

j-Interop: http://www.j-interop.org/