Get the trigger definition.
- RAISEERROR() can write information to the event log.
- PRINT can output the string to the console
Log the the trigger event to the table
Create table to hold the log information
Create the trigger to write to the table
Lets try some DDL statement ,then query the tDDLlog table
Lets expend the XML function