The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL Triggers was one such new feature. We know about triggers as ...

[Microsoft SQL documentation]https://docs.microsoft.com/en-us/sql/?view=sql-server-ver15 [SQL Server technical documentation] https://docs.microsoft.com/en-us/sql/sql ...

SQL Server user-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. The return value can either be ...

Hence they are called DDL triggers. The code samples presented here run on an instance of SQL Server 2008 ... The EVENTDATA() function answers these questions when fired from within a trigger.