SQL Server copies table data between databases

Question

I have a script that I use to copy data from a table in one database to a table in another database on one instance of SQL Server. The script works fine when I am connected to an instance of SQL Server like me, as I have access to both databases. The problem is that this will not happen on the client SQL Server. They have separate logins for each database (SQL authentication accounts). Does anyone know if there is a way to run a script in these circumstances. the script will do something like.

use sourceDB
Insert targetDB.dbo.tblTest (id, test_name)
Select id, test_name from dbo.tblTest

thank

Answer 1

You can configure the linked server:

http://www.databasejournal.com/features/mssql/article.php/3085211/Linked-Servers-on-MS-SQL-Part-1.htm

http://msdn.microsoft.com/en-us/library/ms190479.aspx

script.

Answer 2

. , , . , .

Answer 3

, .

sp_addlinkedsrvlogin 'myDBservername',false,'db_a','db_b','db_b_123'