April 9, 2016 at 12:06 pm
Comments posted to this topic are about the item Auditing DDL Actions
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.
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 question
My 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".
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.
defense? for an intentionally incorrect option? :w00t:
If we didnt have those everyone who answered would be right and QotD would be very boring.
Tom
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy