Question

sqlserver2005帮忙写一个触发器，急用

当某一个表被修改后。。记录修改的sql语句，和修改者的ip等信息，谁知道么，很急，谢谢了

Answer 1

ip地址的没做过,但是做过记录主机名的,你看看行不行?
CREATE
TRIGGER
tr_ALTER_TABLE
ON
DATABASE
FOR
ALTER_TABLE
AS
begin
DECLARE
@Data
XML
SET
@Data
=
EventData()
INSERT
EvtLog
(PostTime,
LoginName,HostName
EventType,
TSQLCommand)
VALUES
(GETDATE(),
CONVERT(NVARCHAR(100),
system_user),
CONVERT(NVARCHAR(100),
host_name()),
@Data.value('(/EVENT_INSTANCE/EventType)[1]',
'nvarchar(100)'),
@Data.value('(/EVENT_INSTANCE/TSQLCommand)[1]',
'nvarchar(2000)')
)
end