Quote:
Originally Posted by Praveenkumarawasthi
I want to test test database Trigers
Then do it. :-)
But seriously: what can we do for you?|||
Quote:
Originally Posted by Praveenkumarawasthi
I want to test test database Trigers
relax, he's kidding :)
if you want to test if it's firing, you can do a command inside the trigger that will allow you to see if it's running. do a simple select, make sure that your select will return just 1 value, say select @.var. i also tried doing a select ... into newtable from inserted and it worked. just make sure the newtable is not existing before the trigger runs.
you can place this in different parts of your trigger. do a select 'over here' so that you can see which part is giving you problem. it's an old way of doing a "debug" for language with no debug mode.
No comments:
Post a Comment