CREATE DATABASE TrgTest;
GO
USE TrgTest;
GO
CREATE TABLE Test
(
ID INT IDENTITY(1,1)
);
GO
CREATE TABLE Logging
(
SomeLoggingCrap VARCHAR(1000) NOT NULL
)
GO
CREATE TRIGGER KittensHateTriggers
ON dbo.Test
FOR INSERT
AS
BEGIN
INSERT INTO Logging(SomeLoggingCrap) SELECT CONCAT('Logged #', ID) FROM inserted
END
GO
DBCC FREEPROCCACHE
INSERT INTO Test DEFAULT VALUES
SELECT * FROM sys.dm_exec_query_stats CROSS APPLY sys.dm_exec_sql_text(sql_handle)