To sxh401(天涯) :
天涯兄,首先建立YourTableLog,比原來的YourTable多兩個欄位用來記錄登陸帳號和刪除時間,然後運行下面的觸發器,然後你在YourTable中刪除一條紀錄,之後再在YourTableLog中查一下原來的紀錄是否在裡面,我試過,可以成功紀錄刪除者,刪除時間,刪除了那筆記錄
CREATE TRIGGER Log_Table ON dbo.YourTable
FOR DELETE
AS
set nocount on
insert into YourTableLog select * , system_user, getdate() from deleted
建立Log_Table,在原來的表上在增加兩個欄位DelBy,DelTime
--****************************************************
--監控刪除資料紀錄,刪除者,刪除時間及刪除了那條紀錄
--****************************************************
CREATE TRIGGER Log_Table ON dbo.YourTable
FOR DELETE
AS
set nocount on
insert into Log_Table select * , system_user, getdate() from deleted
1: select top 0 *,space(20) as 用户,getdate() as 时间 into logTable from tablename
2:如下触发器,但不能知道执行哪条语句。
create trigger 名 on tableName
For delete
As
insert logTable select host_name(),getdate(),* from deleted
1: select *,space(20) as 用户,getdate() as 时间 into logTable from tablename
2:如下触发器,但不能知道执行哪条语句。
create trigger 名 on tableName
For delete
As
insert logTable select host_name(),getdate(),* from deleted