I have few tables(with data) in Server1 and I want have these tables in Server2
(1) First linking both server2 with Server1
EXEC sp_addlinkedsrvlogin @rmtsrvname = 'Server2\SQLEXPRESS', @useself = 'false', @locallogin = 'sa', @rmtuser = 'sa', @rmtpassword = 'Pass123'
(2) Copying/Transfering data
select * into 'Server2\SQLEXPRESS'.MyDB.dbo.aspnet_Membership from 'Server1\SQLEXPRESS'.dbo.aspnet_Membership
But getting error as --> Incorrect syntax near 'Server2\SQLEXPRESS'.
Please check whole query and provide me the solution.
Thanks in advance...