insert data in two servers simultaneously [closed]

Navigation
0

I have my server linked to another server, what I need is a stored procedure where at the moment of inserting data in a table of my server at the same time insert in another table of my linked server

    
asked by Luis Fernando Duron 15.12.2017 в 05:08
source

1 answer

1

Assuming you have your linked server running, use this: 

CREATE PROCEDURE InsertDataLinkedServer
as
INSERT INTO TestTable (COLUMN_NAME) values ('123') -- LOCAL
INSERT INTO [TargetServer].[Database].[dbo].TestTable (COLUMN_NAME) values ('123') -- VINCULADO (LINKED SERVER)

TargetServer = name of your linked server

    
answered by 15.12.2017 / 11:32
source
Error: 'incompatible types: Comparable can not be converted to T' Dialing phone number from Android Studio