How To Know When Trigger Was Updated

In SQL server we often interested in knowing that when last time a specific trigger on a table was updated .

It Requireid especially when a trigger is  being update on regular bases or multiple users are allowed to update that trigger.Here comes the power of System tables in SQL SERVER to track such changes in DatAbase.

So we can write a smiple query on sys.triggers by providing trigger name to find out when it was updated  like

 

SELECT modify_date FROM sys.triggers WHERE name LIKE ‘%TRIGGER_NAME%’