I have SQL Server database on two different servers and IP addresses. When I update the X table on server A, I want to insert into the table Y on server B.
I created a new update in the trigger section and got the inserted - deleted data, but how do I write the code to insert into the SQL Server database (ie server B) in a different IP