Monitor when new logins get created

• ChrisRusty83

  Grasshopper

  Points: 19

  More actions

  January 24, 2014 at 10:16 am

  #396160

  Im looking for a way to setup an alert or maybe even a triiger to see when a new login gets created. I would like to know what the login is and who created it.

• Matt Crowley

  SSCarpal Tunnel

  Points: 4163

  More actions

  January 24, 2014 at 3:02 pm

  #1683280

  You should be able to set up a trigger for the CREATE LOGIN event. Look up create trigger in BOL This would be a server level DDL trigger.

• peterjonk

  SSCommitted

  Points: 1655

  More actions

  January 26, 2014 at 2:32 pm

  #1683394

  In addition I found a login trigger example on the forum.

  http://www.sqlservercentral.com/Forums/Topic848826-1550-1.aspx

  Make sure you understand the concept of server level triggers first before copy-pasting 😉

  __________________
  MS-SQL / SSIS / SSRS junkie
  Visit my blog at dba60k.net