By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,412 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,412 IT Pros & Developers. It's quick & easy.

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

P: 31
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
Oct 17 '09 #1
Share this Question
Share on Google+
1 Reply

P: 31
Thanks any way, I got the solution we can use

EXEC sp_addlinkedserver dataserver, N'SQL Server' &
EXEC sp_addlinkedsrvlogin dataserver, 'false',null, 'sa', 'sqlserver'
Oct 17 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.