September 27, 2010 at 10:29 am
Hi,
This is my first post on SSC but I refer to it often and love it! 😀
I'm a Software Engineer and manage to get by on SQL but I have a problem where I need to obtain details on who disabled some triggers at a database level.
I've been looking through the sys. views but cannot seem to piece together what I need. I see that SQL Server 2008 R2 delivers an auditing solution but this occurred on SQL Server 2005 and there is no custom auditing such as DDL triggers.
Is it possible??
Thanks.
September 27, 2010 at 11:52 am
it's a petty for us all, but "disable trigger" is not a ddl statement !
So you cannot capture it with a ddl trigger.
We have the same issue as you have, we have db-level triggers to capture object creation and only allow udf and sproc for regular project leaders. Only members of the DBA group are allowed for table creation ,...
We discovered our db-trigger got disabled, but weren't able to track who did it.
I recall reading "they" may make it a ddl operation in V-next, but as for now, we stay with this soft spot.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 4, 2010 at 3:21 am
How strange. Thanks for replying, makes sense.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply