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.