用 SQL Server Profiler 选择对象中的object opened事件类,然后在列中按objectname分组,进行跟踪,然后点开你的表名就可以看到操作了
类似于这样。USE AdventureWorks; GO IF OBJECT_ID ('Sales.reminder1', 'TR') IS NOT NULL DROP TRIGGER Sales.reminder1; GO CREATE TRIGGER reminder1 ON Sales.Customer AFTER INSERT, UPDATE AS RAISERROR ('Notify Customer Relations', 16, 10); GO 如果是短期观察,建议使用profiler
选择对象中的object opened事件类,然后在列中按objectname分组,进行跟踪,然后点开你的表名就可以看到操作了
GO
IF OBJECT_ID ('Sales.reminder1', 'TR') IS NOT NULL
DROP TRIGGER Sales.reminder1;
GO
CREATE TRIGGER reminder1
ON Sales.Customer
AFTER INSERT, UPDATE
AS RAISERROR ('Notify Customer Relations', 16, 10);
GO
如果是短期观察,建议使用profiler