Post reply

DDL Triggers to show login/account changes

  • January 11, 2008 at 4:57 am

    #182050

    Hi All,

    I am trying to see if its possible to have a DDL trigger for Create/Alter/Delete login on a SQL 2005 database.

    I would like to know if the details of a login has been changed, who changed it, when it was changed etc. These are the SQL 2005 newly introduced DDL triggers, anyone has any idea as to how to accomplish this ?

  • January 11, 2008 at 5:21 am

    #767038

    Hi Dean,

    Yes, It is possible to create such triggers. These triggers are stored in the master database as objects. The events are related to database changes such as CREATE, ALTER, DROP or security level changes such as CREATE LOGIN, ALTER LOGIN or DROP LOGIN.

    Check out Server-Scoped DDL Triggers and EVENTDATA in Books Online to capture the details.

    Regds,

    R@j

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

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