Sql server Trigger creation date

• akilandeswari.n

  SSC Veteran

  Points: 249

  More actions

  October 7, 2008 at 5:14 am

  #199317

  I wanted to find the date when a triggered is created and modified ?

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  October 7, 2008 at 11:18 am

  #881840

  You can look at "create_date" and "modify_date" from sys.triggers

  SELECT * FROM sys.triggers

  .