> I don't know how a debugger could actually be executing a compiled SP

while

> tracing through its source code. Perhaps it translates the sources into
> DSQL statements and executes

Yes, it does. Just like the one in Database Workbench.

>then rolls back those before moving on...

I do believe you get a dialog for this.

Anyway, in Database Workbench, you can also check your procedure
results because you can open a SQL Editor that uses the same transaction
as the debugger, so you can check if anything is inserted, deleted etc...
in the SQL Editor.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com