Has anyone written somesoftware that could allow you to debug, step through the execution of a trigger with watches? If not it would be a really usfeull tool.
Printable View
Has anyone written somesoftware that could allow you to debug, step through the execution of a trigger with watches? If not it would be a really usfeull tool.
I believe "CAST" does this.
(I assume you mean SQL Server trigger)
Yes I mean SQL Server, could you elaborate a little on CAST, I dont know if its the same but I was thinking an app which acts like vb where I could put stops on sections of the trigger, step through it as it is fired and whatch the status and values of certain variables etc.
CAST as in Caast and Convert is not what I meant.
CAST workbench - but note: The main practical limitation is the $15,000 starting price for one developer license.
Wow that does look good, shame there is absolute 0 chance of my company forking out for that.Quote:
Originally Posted by Merrion
What is the underlying problem that has given rise to this requirement?
You might be able to fix your triggers by creating a stored proc or function that does the logic part of the work and unit-test debugging that?
Well I acually dont have a problem but when I did I thought how usefull it could be.