The mystery of the missing SQL triggers
Posted on 2001-08-21
I am bumbling along trying to customise a software product (Maximo) which is using SQL Server 7 as the back end.
Sadly I've not worked with SQL before and I've had no training so I'm feeling my way a bit.
Today a bizarre thing happened (well it seems bizarre to me anyway).
I had set up several SQL triggers against one of my tables, and they had been working very well. And then someone mentioned they seemed to have stopped working.
I went to have a look at them (using Enterprise manager, which is the only way I know of maintaining them) and they have all DISAPPEARED.
Assuming I don't have a saboteur around the place, and that I am not on drugs (you'll just have to take my word for it) how could this have happened?
Does SQL automatically "manage" them, and store them elsewhere sometimes? Or is this a known SQL bug?
(Come to think of it, several weeks ago I thought this had happened to one of my test databases, but I thought "Nah - it couldn't be - I must be mistaken". And since the DB wasn't important I thought no more of it. But now it seems I WASN'T mistaken. I think they disappeared then also).
Any ideas please? My chances of building a robust system seem pretty slim at the moment.