How to export records from local table to the live server's table?

[Napsterr]

I have a table in local DB. I want to export the records from this table to the live server's database.
It will be better if solution is using stored procedure.
please provide the details.
Thanks in advance.

[khurramzeb]

Hi Napsterr

Check this link it will solve ur problem

http://social.msdn.microsoft.com/For...6-2498ac7a4e79

[Napsterr]

I found it myself
The important thing is to Connect to the live SQL Server
using sp_addlinkedser ver
And then we can do any operations on that database