Trigger vanished from enterprise studio but still running in background
Posted on 2008-06-19
I recently created a trigger to pull some information from one table into another once certain fields were updated.
Once i was happy that it was working fine i left it alone and it has been working since without any problems.
I now need to modify the code slightly but i cannot find it through management studio; i have even tried running the following SQL on the server and it is not being found.
select object_name(id), object_name(deltrig),
where xtype ='U'
(deltrig > 0 or instrig > 0 or updtrig > 0)
The wierd thing is that it is obviously still running because records are benig added to the table when updates take place.
Does anyone have any ideas what may be causing this?