How to execute 1 stored procedure with two different servers in sqlserver

See more:

SQL

server

Hi,

In my project architecture, we heave two servers node1 and node2. node1 we are performing all CRUD operations on physical tables and node2 we are performing only select statements.

But my stored procedures having below structure

insert
|
select
|
update

How can i rewrite my stored procedure to executing insert and update as node1 and select from node2.

Thanks for advance, still need any clarification ping me.

What I have tried:

i got only one suggestion from my Architect , re write the code using .net language functions.