I have 2 stored procedures: demo3 and demo3b
what I want to do is capture the updated row before it is updated and after it is updated. the before and after are inserted into table Emp_Tracker
alter table employee add trigger update demo3 when I list triggers, it shows up as an update trigger
alter table employee add trigger update after demo3b list triggers and get: update trigger: No Trigger Defined After Update Trigger: demo3b
Why did the update trigger demo3 disappear?
Both of these triggers fire correctly when I do them one at a time.
Bernie Lis
