sql - Insert Data From One Server To Another? -

If I want to run such a query in SQL Server, then how do I query the same query to a server Can I add to another?

I tried to add "server name 1". Before "[DatabaseName1]" [dbo] ... and "[server name 2]". "[DatabaseName2]. [DBO] ..." but it does not seem to work.

  INSERT [DatabaseName1]. [Dbo]. [Tagalnam] ([field name]) [tablename]  

Is this possible? 2] [DBO] from the [] [field name] [field name]. "Itemprop =" text ">

Yes, Use the name before the whole object name:

  myserver.mydatabase.dbo.mytable  

Although you first set up the linked server Look at the linked server in Bol