Insert records into servermachine from local
I have created table in Server machine under sql database.Now I'm trying to move all data contents of the table from my local machine to server machine..
But I couldn't use the following query since it says "sys.servers doesn't have the server name".
select * into dbo.tablename from servername.dbo.epicay.TableName
How to proceed..