passing db table values from one sql server instance to another sql server instance

[kirankumarn]

I have a table "Client" in database "Sample" in a sql server instance "sa" i want to pass all the table"Client" values into another sql server instance "demo" by runing just an stored procedure.

Thanks in advance

[kirankumarn]

Thanks any way, I got the solution we can use

EXEC sp_addlinkedser ver dataserver, N'SQL Server' &
EXEC sp_addlinkedsrv login dataserver, 'false',null, 'sa', 'sqlserver'