SQL Server COPY TABLE from another SQL Server
Posted by: SQL Server DBA,
on 02 Feb 2012 |
View original | Bookmarked: 0 time(s)
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and reference the Linked Server in the SELECT statement.
1) Create linked server
/****** Object: LinkedServer [SERVER1\SQL_SERVER_INSTANCE_1] Script Date: 02/02/2012 09:29:33 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'SERVER1\SQL_SERVER_INSTANCE_1', @srvproduct=N'SQL Server'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC...