Auditing DDL Actions

Question

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 1

Steve, the right event is "DROP TABLE" instead of "DELETE TABLE".

George Vobr SSChampion Points: 10009 More actions · Answer 2

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.

Horia Negrila SSC Veteran Points: 252 More actions · Answer 3

Nice question, thanks.

I guess it's time to review my DDL triggers 🙂

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

As someone who doesn't use a lot of triggers, I got to learn something new. Thanks.

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 5

Yes, learned something today. Thanks for spoting this.

dstrickrott SSCommitted Points: 1951 More actions · Answer 6

Learned something new, like a few others have already mentioned. Thanks Steve.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

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

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 8

Carlo Romagnano (4/11/2016)
Steve, the right event is "DROP TABLE" instead of "DELETE TABLE".

That's an incorrect answer.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

Well, in your defense, we used to delete files which are now just tables.

TomThomson SSC Guru Points: 104773 More actions · Answer 10

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