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%’
