title: (Select * from table) from another pc without linked server
body: <p>I am trying to find if there is any way, selecting table from another pc, 'without' creating a linked server.<br>
  I found an example which i setting up my sql connection string inside my query, but it gives me error that i need to create a linked server.</p>
  
  <pre><code>SELECT * FROM OPENDATASOURCE (
      'SQLNCLI'
      ,'Data Source=192.168.0.3,1433;Initial Catalog=wiorder;User ID=admin;Password=1234').inventorymaster
  </code></pre>
  
  <h2>Solved by Dan.</h2>
  
  <p>When i am trying to insert from destination pc to local pc i am getting error:  </p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 5, Line 4
    Msg 8101, Level 16, State 1, Line 3
    An explicit value for the identity column in table 'InventoryMaster' can only be specified when a column list is used and IDENTITY_INSERT is ON.  </p>
  </blockquote>
  
  <p>Here is my query</p>
  
  <pre><code>SET IDENTITY_INSERT InventoryMaster ON
  
  insert into InventoryMaster 
  SELECT * FROM OPENDATASOURCE (
  'SQLNCLI'
  ,'Data Source=192.168.0.3,1433;Initial Catalog=WiOrder;User ID=admin;Password=1234').WiOrder.dbo.inventorymaster  
  
  SET IDENTITY_INSERT InventoryMaster OFF
  </code></pre>