|
-
Nov 16th, 2005, 05:31 AM
#1
Thread Starter
Frenzied Member
Trigger debugger
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.
-
Nov 16th, 2005, 08:11 AM
#2
Re: Trigger debugger
I believe "CAST" does this.
(I assume you mean SQL Server trigger)
-
Nov 17th, 2005, 06:49 AM
#3
Thread Starter
Frenzied Member
Re: Trigger debugger
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.
Last edited by FishGuy; Nov 18th, 2005 at 05:25 AM.
-
Nov 18th, 2005, 08:34 AM
#4
Re: Trigger debugger
CAST workbench - but note: The main practical limitation is the $15,000 starting price for one developer license.
-
Nov 18th, 2005, 10:53 AM
#5
Thread Starter
Frenzied Member
Re: Trigger debugger
 Originally Posted by Merrion
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.
-
Nov 22nd, 2005, 04:55 AM
#6
Re: Trigger debugger
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?
-
Nov 22nd, 2005, 06:41 AM
#7
Thread Starter
Frenzied Member
Re: Trigger debugger
Well I acually dont have a problem but when I did I thought how usefull it could be.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote