[SQL ] 用Trigger紀錄LOG的問題

[lisyu (游小蝦)]

目前的Trigger寫法如下

CREATE TRIGGER [tri_TABLE1_UPD] ON [TABLE1] AFTER UPDATE
AS
BEGIN
    DECLARE @record XML
    DECLARE @IsType TINYINT
    SET @IsType=''
    IF EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted) AND
    (SELECT COUNT(*) FROM inserted
            WHERE (LEFT(Field1,1)='Y'))>0
        SET @IsType = 2    --Update

    IF (@IsType <>'')
    BEGIN
        SET @record=(SELECT * FROM inserted FOR XML RAW('Customers'),
                      ELEMENTS,ROOT)
        INSERT INTO [LOG]([dbname],[recoder],[istype])
                      VALUES('Customers',@record  ,1)
        SET @record=(SELECT * FROM deleted FOR XML RAW('Customers'),
                      ELEMENTS,ROOT)
        INSERT INTO [LOG]([dbname],[recoder],[istype])
                      VALUES('Customers',@record  ,3)
    END
END;

不過目前紀錄的只有資料庫的內容變化
請問如果要記錄是誰修改的例如IP或來自哪台電腦改的
有辦法抓到相關資料嗎?

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 218.210.209.2
→ bohei:可以找找V$SESSION 看有沒有你要的資料XD