BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted	 	EXEC InsertIntoAuditLog 'CustomActionAdapter', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER CustomInputAdapter_AuditInsert   ON  CustomInputAdapter   AFTER INSERTAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #inserted		EXEC InsertIntoAuditLog 'CustomInputAdapter', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER CustomInputAdapter_AuditUpdate    ON  CustomInputAdapter   AFTER UPDATEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted  FROM deleted	SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted			EXEC InsertIntoAuditLog 'CustomInputAdapter', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER CustomInputAdapter_AuditDelete   ON  CustomInputAdapter   AFTER DELETEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted	 	EXEC InsertIntoAuditLog 'CustomInputAdapter', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER CustomOutputAdapter_AuditInsert   ON  CustomOutputAdapter   AFTER INSERTAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #inserted		EXEC InsertIntoAuditLog 'CustomOutputAdapter', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER CustomOutputAdapter_AuditUpdate    ON  CustomOutputAdapter   AFTER UPDATEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted  FROM deleted	SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted			EXEC InsertIntoAuditLog 'CustomOutputAdapter', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER CustomOutputAdapter_AuditDelete   ON  CustomOutputAdapter   AFTER DELETEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted	 	EXEC InsertIntoAuditLog 'CustomOutputAdapter', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Device_AuditInsert   ON  Device   AFTER INSERTAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #inserted		EXEC InsertIntoAuditLog 'Device', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Device_AuditUpdate    ON  Device   AFTER UPDATEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted  FROM deleted	SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted			EXEC InsertIntoAuditLog 'Device', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Device_AuditDelete   ON  Device   AFTER DELETEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted	 	EXEC InsertIntoAuditLog 'Device', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Historian_AuditInsert   ON  Historian   AFTER INSERTAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #inserted		EXEC InsertIntoAuditLog 'Historian', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Historian_AuditUpdate    ON  Historian   AFTER UPDATEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted  FROM deleted	SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted			EXEC InsertIntoAuditLog 'Historian', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Historian_AuditDelete   ON  Historian   AFTER DELETEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted	 	EXEC InsertIntoAuditLog 'Historian', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Measurement_AuditInsert   ON  Measurement   AFTER INSERTAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), SignalID) FROM #inserted		EXEC InsertIntoAuditLog 'Measurement', 'SignalID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Measurement_AuditUpdate    ON  Measurement   AFTER UPDATEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted  FROM deleted	SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), SignalID) FROM #deleted			EXEC InsertIntoAuditLog 'Measurement', 'SignalID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Measurement_AuditDelete   ON  Measurement   AFTER DELETEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), SignalID) FROM #deleted	 	EXEC InsertIntoAuditLog 'Measurement', 'SignalID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Node_AuditInsert   ON  Node   AFTER INSERTAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #inserted		EXEC InsertIntoAuditLog 'Node', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Node_AuditUpdate    ON  Node   AFTER UPDATEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted  FROM deleted	SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted			EXEC InsertIntoAuditLog 'Node', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Node_AuditDelete   ON  Node   AFTER DELETEAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted	 	EXEC InsertIntoAuditLog 'Node', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OtherDevice_AuditInsert   ON  OtherDevice   AFTER INSERTAS BEGIN		SET NOCOUNT ON;		SELECT * INTO #inserted FROM inserted 	DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #inserted		EXEC InsertIntoAuditLog 'OtherDevice', 'ID', @id, '0', '1'		DROP TABLE #inserted 

Lines 501–1000 of 1968. Previous lines Load more