--创建空数据库
create database chl_fromempty
use chl_fromempty
--创建表存储xml数据
create table chl_ddlevendate(fdata xml,fid int identity(1,1),fdatetime datetime default getdate())
--创建DDL触发器获取触发事件的详细信心
create trigger chl_tableddl_getdata on database
for create_table,alter_table,drop_table
as
insert into chl_ddlevendate(fdata) select EVENTDATA()
--测试,创建表
create table chl001(a int,b char(1),c date)
--查询获取到的XML
select * from chl_ddlevendate
--以下为获取到的xml的内容
<EVENT_INSTANCE>
<EventType>CREATE_TABLE</EventType>
<PostTime>2019-08-15T09:48:23.967</PostTime>
<SPID>61</SPID>
<ServerName>HANLIN-PC</ServerName>
<LoginName>sa</LoginName>
<UserName>dbo</UserName>
<DatabaseName>chl_fromempty</DatabaseName>
<SchemaName>dbo</SchemaName>
<ObjectName>chl001</ObjectName>
<ObjectType>TABLE</ObjectType>
<TSQLCommand&