SQL Server EventData () function to get DDL trigger information _mssql

Copy Code code as follows:

--Create a log table
CREATE TABLE triggerlog (loginfo XML)

--Create a dummy table to delete later on
CREATE TABLE tabletodelete (Id int PRIMARY KEY)

--Create a new table as a delete test table
INSERT into Tabletodelete VALUES (1)
Go

--Creates a drop Table's DDL
CREATE TRIGGER Stoptabledrop on DATABASE after drop_table
As
DECLARE @EventData as XML
SET @EventData = EventData ()--The DDL information must be intercepted before rollback
ROLLBACK
PRINT ' DROP TABLE attempt in database ' + db_name () + '. '
INSERT into Triggerlog VALUES (@EventData)

Perform the following delete operation:
DROP TABLE Tabletodelete
Triggers the above DDL, thereby rolling back the operation.
Execute the following sql:
SELECT * from Triggerlog
View the DDL information just intercepted.