We just discovered that one of the insert triggers for a table has disappeared. A check of a backup from a few weeks ago shows it was there at that point, but none of the development staff believes they did anything to cause the disappearance. This is the second instance where this appears to have happened since we upgraded to SQL Server 2000. Has anyone else had this experience?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Disappearing Triggers in SQL Server 2000
- Thread starter WendellB
- Start date
tlbroadbent
MIS
Only when someone or some process deletes the trigger. I don't beleive it happens because of a bug in SQL Server. At least, we have not experienced such a problem. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
