if exists (select * from dbo.sysobjects where id = object_id( _
  N'[dbo].[trigger_contries_UPDATE]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[trigger_contries_UPDATE]
GO
 
CREATE TRIGGER trigger_contries_UPDATE
ON  tm_contries
FOR UPDATE
AS
DECLARE @sessionID VARCHAR(50)
DECLARE @filter VARCHAR(255)
SELECT @filter = 'contryID=' + CAST(contryID AS VARCHAR(255)) FROM inserted
DECLARE tnames_cursor CURSOR
FOR
SELECT sessionID FROM tm_sessions
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @sessionID
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
INSERT INTO tm_changes VALUES (@sessionID,@filter,'tm_contries','update')
END
FETCH NEXT FROM tnames_cursor INTO @sessionID
END
CLOSE tnames_cursor
DEALLOCATE tnames_cursor
GO
 
if exists (select * from dbo.sysobjects where id = object_id( _
  N'[dbo].[trigger_contries_INSERT]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[trigger_contries_INSERT]
GO
 
CREATE TRIGGER trigger_contries_INSERT
ON  tm_contries
FOR INSERT
AS
DECLARE @sessionID VARCHAR(50)
DECLARE @filter VARCHAR(255)
SELECT @filter = 'contryID=' + CAST(contryID AS VARCHAR(255)) FROM inserted
DECLARE tnames_cursor CURSOR
FOR
SELECT sessionID FROM tm_sessions
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @sessionID
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
INSERT INTO tm_changes VALUES (@sessionID,@filter,'tm_contries','insert')
END
FETCH NEXT FROM tnames_cursor INTO @sessionID
END
CLOSE tnames_cursor
DEALLOCATE tnames_cursor
GO
 
if exists (select * from dbo.sysobjects where id = object_id( _
  N'[dbo].[trigger_contries_DELETE]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[trigger_contries_DELETE]
GO
 
CREATE TRIGGER trigger_contries_DELETE
ON  tm_contries
FOR DELETE
AS
DECLARE @sessionID VARCHAR(50)
DECLARE @filter VARCHAR(255)
SELECT @filter = 'contryID=' + CAST(contryID AS VARCHAR(255)) FROM deleted
DECLARE tnames_cursor CURSOR
FOR
SELECT sessionID FROM tm_sessions
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @sessionID
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
INSERT INTO tm_changes VALUES (@sessionID,@filter,'tm_contries','delete')
END
FETCH NEXT FROM tnames_cursor INTO @sessionID
END
CLOSE tnames_cursor
DEALLOCATE tnames_cursor
GO