I have the same application running on 2x platforms. Both systems have a dedicated DB server, one runs SQL Server 2005, the other 2008 (R2)
On both dbs I have a table and on that table there should be 2x triggers, one managing inserts, the other updates.
On the 2005 server, I have no issues.
On the 2008 server, the insert trigger is fine but the update trigger keeps disappearing / vanishing without any explanation. Literally, I create the trigger from a stored script, refresh the triggers branch and I can see it. I'll come back 10-15 mins later and refresh again - I can see the insert trigger but the update trigger has gone. I haven't dropped the trigger nor the table nor do I believe anyone else could or would be taking actions which conflicted with my work (e.g. colleagues working on the same db instance).
The triggers aren't complex - script is attached.
Thanks in advance. Changes-to-IssueHeader-Triggers-.sql