AS BEGIN		SET NOCOUNT ON;		SELECT * INTO #deleted FROM deleted			DECLARE @id NVARCHAR(MAX)			SELECT @id = CONVERT(NVARCHAR(MAX), ID) FROM #deleted	 	EXEC InsertIntoAuditLog 'OutputStreamMeasurement', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Phasor_AuditInsert   ON  Phasor   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 'Phasor', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Phasor_AuditUpdate    ON  Phasor   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 'Phasor', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Phasor_AuditDelete   ON  Phasor   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 'Phasor', 'ID', @id, '1'			DROP TABLE #deleted ENDGO CREATE TRIGGER Alarm_AuditInsert   ON  Alarm   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 'Alarm', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO CREATE TRIGGER Alarm_AuditUpdate    ON  Alarm   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 'Alarm', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Alarm_AuditDelete   ON  Alarm   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 'Alarm', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Vendor_AuditInsert   ON  Vendor   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 'Vendor', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Vendor_AuditUpdate    ON  Vendor   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 'Vendor', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Vendor_AuditDelete   ON  Vendor   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 'Vendor', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER VendorDevice_AuditInsert   ON  VendorDevice   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 'VendorDevice', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER VendorDevice_AuditUpdate    ON  VendorDevice   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 'VendorDevice', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER VendorDevice_AuditDelete   ON  VendorDevice   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 'VendorDevice', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Subscriber_AuditInsert   ON  Subscriber   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 'Subscriber', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Subscriber_AuditUpdate    ON  Subscriber   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 'Subscriber', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER Subscriber_AuditDelete   ON  Subscriber   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 'Subscriber', 'ID', @id, '1'			DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER MeasurementGroup_AuditInsert   ON  MeasurementGroup   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 'MeasurementGroup', 'ID', @id, '0', '1'		DROP TABLE #inserted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER MeasurementGroup_AuditUpdate    ON  MeasurementGroup   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 'MeasurementGroup', 'ID', @id		DROP TABLE #inserted	DROP TABLE #deleted ENDGO SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE TRIGGER MeasurementGroup_AuditDelete   ON  MeasurementGroup   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 'MeasurementGroup', 'ID', @id, '1'			DROP TABLE #deleted ENDGO

Lines 1501–1968 of 1968. Previous lines