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 …

Read more