CREATE TABLE [dbo].[Таблица1](
	[F_Division] [tinyint] NOT NULL,
	[F_Subdivision] [int] NOT NULL,
	[LINK] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	... другие столбцы
	CONSTRAINT [PK_Таблица1] PRIMARY KEY CLUSTERED 
	(
		[LINK] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 95) ON [Data]
) ON [Data]
GO
ALTER TABLE [dbo].[Таблица1] ADD  CONSTRAINT [DF_Таблица1_LINK]  DEFAULT (newid()) FOR [LINK]
GO

CREATE TRIGGER [dbo].[TRD_Таблица1] ON [dbo].[Таблица1]
INSTEAD OF DELETE
/* Опции Merge, Transactional репликации */
/*Opt.1*/NOT FOR REPLICATION
/* Опции Merge, Transactional репликации */
AS 
/* Опции Transactional репликации */
/*Opt.1*/ 
/* Опции Transactional репликации */
--Стандартный триггер для обновления даты модификации записей и идентификатора пользователя.
SET NOCOUNT, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL ON
SET NUMERIC_ROUNDABORT, XACT_ABORT, CURSOR_CLOSE_ON_COMMIT OFF

DELETE R FROM Таблица2 R INNER JOIN DELETED I ON I.LINK = R.LINK
	
DELETE NI
FROM Таблица1 NI
INNER JOIN DELETED D
	ON D.LINK = NI.LINK
;

CREATE TABLE [dbo].[Таблица2](
	[F_Networks] [uniqueidentifier] NOT NULL,
	[LINK] [uniqueidentifier] NOT NULL,
... столбцы...
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[LINK_Imp] [varchar](36) NULL,
 CONSTRAINT [PK_Таблица2] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Indexes]
) ON [Data] TEXTIMAGE_ON [Data]
GO

CREATE TRIGGER [dbo].[bng_TRD_Таблица1_Log] ON [dbo].[Таблица1]
AFTER DELETE  
	AS 
BEGIN
	SET NOCOUNT, XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL ON
	SET NUMERIC_ROUNDABORT, CURSOR_CLOSE_ON_COMMIT OFF

IF ( (SELECT TRIGGER_NESTLEVEL( OBJECT_ID('dbo.TRUD_Таблица1_Log') , 'AFTER' , 'DML' ) ) > 1 ) RETURN 

DECLARE @cnt INT
SET @cnt = (SELECT COUNT(*) FROM dbo.Таблица2)

INSERT dbo.bng_ni_log(LINK, cnt)
SELECT LINK, @cnt
FROM DELETED

END
GO

ALTER TABLE [dbo].[Таблица1] ENABLE TRIGGER [bng_TRD_Таблица1_Log]
GO

CREATE TRIGGER [dbo].Триггер ON [dbo].[Таблица2]
FOR DELETE
	AS 
BEGIN
	SET NOCOUNT, XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL ON
	SET NUMERIC_ROUNDABORT, CURSOR_CLOSE_ON_COMMIT OFF

	IF ( (SELECT TRIGGER_NESTLEVEL( OBJECT_ID('dbo.Триггер') , 'BEFORE' , 'DML' ) ) > 1 ) RETURN 

	INSERT dbo.bng_nr_log(EventType, Parameters, EventInfo)
	DBCC INPUTBUFFER (@@spid);

	IF @@ROWCOUNT = (SELECT COUNT(*) FROM [dbo].Таблица2)
	BEGIN
	   ROLLBACK;
	   RETURN;
	END
END
GO