ddl 触发
USE Test;
GO
CREATE TABLE alter_log (PostTime datetime, DB_User nvarchar(100), Event nvarchar(100),dbName nvarchar(32), TSQL nvarchar(2000),EventData xml);
GO
CREATE TRIGGER ddl_alter_log
ON all server
after CREATE_TABLE,DROP_TABLE,ALTER_TABLE,CREATE_PROCEDURE,ALTER_PROCEDURE,DROP_PROCEDURE
AS
INSERT into Test..alter_log
(PostTime, DB_User, Event, dbName,TSQL)
VALUES
(GETDATE(),
CONVERT(nvarchar(100), CURRENT_USER),
EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)'),
DB_NAME(),
EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2000)') )
GO
ENABLE TRIGGER ddl_alter_log ON ALL SERVER
这个有什么问题吗,该怎么处理呢?