Loading

Stored Procedure

Carlos Sanchez

Hi everyone!

I need a query to retrieve data from a server and insert them into another server. I was thinking to create a stored procedure, but how can I pass the server name as parameter from C# and how can I concatenate it to the command?

The query I need is something like the following:

INSERT INTO Server1.Table SELECT * FROM Server2.Table

Thank you in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ryan Alford18y ago
after linking the server, the syntax will be "ServerName.DatabaseName.Owner.Table" or "ServerName.DatabaseName.Owner.StoredProcedureName"
18y ago
If you want to make the connection of to database of different server then you have to first link those server then you can use transfer the data between those server database.

For established the link between the servers you have to use "sp_addlinkedserver"