Post reply

DDL Trigger database options

  • September 25, 2008 at 7:45 am

    #124812

    Hey all,

    I can't seem to find a good reference for all the available DDL Database Trigger options. More so than anything, I'm curious to exactly what is included in FOR DDL_DATABASE_LEVEL_EVENTS. I'm assuming this is everything ... drop/create/modify? Yet does it include more stuff that I wouldn't care about, like execute? Any good articles/links would be much appreciated.

    Thanks

  • September 25, 2008 at 10:13 am

    #877145

    Have a look at the page in BoL titled "DDL Event Groups for Use with Event Notifications"

    There are a few events there that aren't included in DDL triggers, but it is the closest article available that I've found.

    (SQL Server Database > Engine Designing and Creating Databases > Event Notifications (Database Engine) > Designing Event Notifications > DDL Event Groups for Use with Event Notifications )

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 25, 2008 at 10:15 am

    #877147

    Perfect, thanks Gila.

Viewing 3 posts - 1 through 2 (of 2 total)

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