CREATE TRIGGER [dbo].[AR_BS_Pays] 
   ON  [dbo].[BS_Pays] 
   After INSERT,UPDATE
AS 
BEGIN
	SET NOCOUNT ON;

INSERT INTO [DataBaseArchive].[dbo].[BS_Pays]
           ([ID]
           ,[Type]
           ,[Cash]
           ,[adddate]
           ,[UserID]
           ,[Sign]
           ,[Comment]
           ,[DateEdit])
(SELECT [ID]
      ,[Type]
      ,[Cash]
      ,[adddate]
      ,[UserID]
      ,[Sign]
      ,[Comment]
	  ,GetDate()
	FROM [BS_Pays]
	WHERE [id] in (Select [id] from inserted))