Insert records into servermachine from localI 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..