Skip to main content

Trigger INSERT & DELETE From 2 Different Database Server



TRIGGER INSERT :
create trigger [dbo].[trigger name] on [dbo].[table name 1st]
after INSERT
as
begin
insert into [IP Address destination server].[2nd database name].[dbo].[table name 2nd]
select [Material]
      ,[MaterialDescr]
      ,[MatlGroup]
      ,[Createdby] from inserted
end



TRIGGER DELETE :
create trigger [dbo].[trigger name] on [dbo].[table name 1st]
for DELETE
as
declare @ID varchar(15)
SET @ID = (select [Material] from deleted)
begin
delete from [IP Address destination server].[2nd database name].[dbo].[table name 2nd]
 where MATERIAL = @ID

end









Comments

Popular posts from this blog

Pop Up message Visual Studio "The operation could not be completed. The process cannot access the file because it is being used by another process"

Run your Visual Studio as Administrator account

Create Comment As .xls In Farpoint Spread

  Private Sub TAGS_PARENTING()         Dim DTPopUp As New DataTable         With DTPopUp             .Columns.Add("SEQ", GetType(String))             .Columns.Add("QTY", GetType(String))             .Columns.Add("ETD", GetType(String))             .Columns.Add("ETA", GetType(String))             DTPopUp = MePostab_Control.Cari_TAG_PARENTING         End With         With FPPOSTAB             For GG As Integer = 0 To .ActiveSheet.RowCount - 1             ...