22,207
社区成员
发帖
与我相关
我的任务
分享
USE Test
GO
SELECT ID=IDENTITY(INT,1,1),name INTO TriEvent FROM sys.tables
GO
CREATE TABLE TriEventHIST(HostName sysname,IPAddress VARCHAR(50),UserName VARCHAR(50),CreateDate DATETIME DEFAULT GETDATE())
go
CREATE TRIGGER tr_dTriEvent ON TriEvent
AFTER DELETE
AS
BEGIN
IF @@ROWCOUNT>0
INSERT INTO TriEventHIST(HostName,IPAddress,UserName)
SELECT HOST_NAME(),CAST(CONNECTIONPROPERTY('client_net_address') AS varchar(50)),ORIGINAL_LOGIN()
END
GO
DELETE TriEvent WHERE ID=1
go
SELECT * FROM TriEventHIST
DROP TABLE dbo.TriEventHIST,TriEvent
SELECT HOST_NAME() + '\' + CURRENT_USER + '\' + APP_NAME() AS loguser;
加到你的触发器里面,获取delete时的工作机器,登录名以及使用什么应用程序.