July 13, 2006 at 8:35 am
Hi guys, I'm new and I don't know if this is the right place to put my question, I have database working under sql server 2000 and I have several triggers on different tables, there is one trigger that its been erased, I put it again and one or two months later it is erased again, i asked the dba's and they told me that they didn´t do it, do you know how can a see who is dropping the trigger? is this information stored in the log?
Thanks in advance
July 14, 2006 at 9:24 pm
unless you want to run a light weight server side trace
August 22, 2006 at 2:01 pm
Well unfortunately, with SQL2000 you only have the option of a trace as mentioned.
Not that it's relevent, but SQL2005 captures this kind of information! Roll on our upgrade to SQL2k5!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply