title: error in linked server in sql server 2008 r2
body: <p>i have a table <code>tmpDTTransfer</code> in my database <code>demo</code>:-</p>
  
  <pre><code> GO
   /****** Object:  Table [dbo].[tmpDTTransfer]   
      Script Date: 08/10/2015  12:41:21 ******/
          SET ANSI_NULLS ON
            GO
              SET QUOTED_IDENTIFIER ON
            GO
              SET ANSI_PADDING ON
           GO
  
         CREATE TABLE [dbo].[tmpDTTransfer](
            [id] [int] IDENTITY(1,1) NOT NULL,
            [Code] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [Transfer] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
   CONSTRAINT [DF_tmpDTTransfer_Transfer]  DEFAULT ('N')
  ) ON [PRIMARY]
  
   GO
   SET ANSI_PADDING OFF
  </code></pre>
  
  <p>now i insert data into this table:-</p>
  
  <pre><code>         id Code           Transfer
           -----------------------------
           1  L-57           y
           2  BP _162        y
           3  RS_400         n
           4  jhony_12000    n
           5  enti_525       y
  </code></pre>
  
  <p>i have also a linked server.i</p>
  
  <p>i am trying to copy this table in another database <code>Audit</code> which are present on another server,then i try this query for this task:-</p>
  
  <pre><code>   select * into [192.168.1.6].[Audit].[dbo].[tmpDTTransfer]
      from [tmpDTTransfer] 
  </code></pre>
  
  <p>error is as follows:-</p>
  
  <blockquote>
    <p>Msg 117, Level 15, State 1, Line 2
    The object name '192.168.1.6.Audit.dbo.tmpDTTransfer' contains more than the maximum number of prefixes. The maximum is 2.</p>
  </blockquote>