Hello,
I have 2 SQL server databases.
Have added the linked server on server_A to add server_B
I want to insert the data from a storedprocedure which selects the data from server_A.pubs.dbo.titles to server_b.pubs.dbo.titles
This stored procedure is on server_A.
Its not completing the process, when i execute the SP
Can you please tell me how to use openquery to insert the data to server_B database?
thanks
I have 2 SQL server databases.
Have added the linked server on server_A to add server_B
I want to insert the data from a storedprocedure which selects the data from server_A.pubs.dbo.titles to server_b.pubs.dbo.titles
This stored procedure is on server_A.
Its not completing the process, when i execute the SP
Can you please tell me how to use openquery to insert the data to server_B database?
thanks