ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OtherDevice_AuditUpdate    ON  OtherDevice   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 'OtherDevice', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OtherDevice_AuditDelete   ON  OtherDevice   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 'OtherDevice', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStream_AuditInsert   ON  OutputStream   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 'OutputStream', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStream_AuditUpdate    ON  OutputStream   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 'OutputStream', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStream_AuditDelete   ON  OutputStream   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 'OutputStream', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDevice_AuditInsert   ON  OutputStreamDevice   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 'OutputStreamDevice', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDevice_AuditUpdate    ON  OutputStreamDevice   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 'OutputStreamDevice', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDevice_AuditDelete   ON  OutputStreamDevice   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 'OutputStreamDevice', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDeviceAnalog_AuditInsert   ON  OutputStreamDeviceAnalog   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 'OutputStreamDeviceAnalog', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDeviceAnalog_AuditUpdate    ON  OutputStreamDeviceAnalog   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 'OutputStreamDeviceAnalog', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDeviceAnalog_AuditDelete   ON  OutputStreamDeviceAnalog   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 'OutputStreamDeviceAnalog', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDeviceDigital_AuditInserted   ON  OutputStreamDeviceDigital   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 'OutputStreamDeviceDigital', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDeviceDigital_AuditUpdate    ON  OutputStreamDeviceDigital   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 'OutputStreamDeviceDigital', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDeviceDigital_AuditDelete   ON  OutputStreamDeviceDigital   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 'OutputStreamDeviceDigital', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDevicePhasor_AuditInsert   ON  OutputStreamDevicePhasor   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 'OutputStreamDevicePhasor', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDevicePhasor_AuditUpdate    ON  OutputStreamDevicePhasor   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 'OutputStreamDevicePhasor', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamDevicePhasor_AuditDelete   ON  OutputStreamDevicePhasor   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 'OutputStreamDevicePhasor', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamMeasurement_AuditInsert   ON  OutputStreamMeasurement   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 'OutputStreamMeasurement', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamMeasurement_AuditUpdate    ON  OutputStreamMeasurement   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 'OutputStreamMeasurement', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER OutputStreamMeasurement_AuditDelete   ON  OutputStreamMeasurement   AFTER DELETE

Lines 1001–1500 of 1968. Previous lines Load more