|
Posted by serge on 01/25/06 20:29
When i debug a trigger is it possible to add a WATCH
on the INSERTED or DELETED?
I think not, at least I couldn't figure out a way to do so.
Does someone have a suggestion on how I can see the values?
I did try to do something like
INSERT INTO TABLE1(NAME)
SELECT NAME FROM INSERTED
but this didn't work. When the trigger completed and I
went to see the TABLE1, there were no records in it.
Are there any documents, web links that describe ways
of debugging the trigger's INSERTED and DELETED?
Thank you
Navigation:
[Reply to this message]
|