Steve Jones - SSC Editor
April 9, 2016 at 12:06 pm
Comments posted to this topic are about the item Auditing DDL Actions
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
April 11, 2016 at 12:56 am
Steve, the right event is "DROP TABLE" instead of "DELETE TABLE".
April 11, 2016 at 1:28 am
This was removed by the editor as SPAM
April 11, 2016 at 5:09 am
Thanks for the interesting question. If you should really cover all the events on any table, it would be appropriate to use DDL_TABLE_VIEW_EVENTS.
April 11, 2016 at 5:51 am
Nice question, thanks.
I guess it's time to review my DDL triggers 🙂
April 11, 2016 at 6:33 am
As someone who doesn't use a lot of triggers, I got to learn something new. Thanks.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions
April 11, 2016 at 9:44 am
Yes, learned something today. Thanks for spoting this.
April 11, 2016 at 2:57 pm
Learned something new, like a few others have already mentioned. Thanks Steve.
April 12, 2016 at 5:26 am
Thanks for the question.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
April 12, 2016 at 9:14 am
Carlo Romagnano (4/11/2016)Steve, the right event is "DROP TABLE" instead of "DELETE TABLE".
Carlo Romagnano (4/11/2016)
That's an incorrect answer.
April 12, 2016 at 11:22 am
Well, in your defense, we used to delete files which are now just tables.
April 20, 2016 at 4:54 am
Iwas Bornready (4/12/2016)Well, in your defense, we used to delete files which are now just tables.
Iwas Bornready (4/12/2016)
defense? for an intentionally incorrect option? :w00t:
If we didnt have those everyone who answered would be right and QotD would be very boring.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply