locked
trigger on drop create view RRS feed

  • Question

  • what kind of trigger is for drop or create view.
    • Edited by George Zhou Tuesday, September 4, 2012 3:13 PM
    Tuesday, September 4, 2012 3:12 PM

Answers

All replies

  • if you want to log when a view is created or dropped, you can best activate DB audit

    Geert Vanhove

    Tuesday, September 4, 2012 3:19 PM
  • Hello George,

    There are DDL Trigger available for Create/Drop objects events in SQL Server.


    Olaf Helper
    Blog Xing

    • Proposed as answer by Tom Phillips Tuesday, September 4, 2012 9:00 PM
    • Marked as answer by Shulei Chen Wednesday, September 12, 2012 8:57 AM
    Tuesday, September 4, 2012 4:06 PM