title: The object name contains more than the maximum number of prefixes. The maximum is 3
body: <p>My stored procedure is trying to write a record in to a database on another Server. The statement is here:</p>
  <pre><code>IF @Builds &gt; 0
     BEGIN
          SET @DPU = @Failures / @Builds
          INSERT INTO SQL05.ManufacturingPortal.dbo.OPC.WriteRequests (ID, RegisterID, Value, RequestedDate, IsCompleted)
          VALUES(@PLCID, 'F8:10' , CAST(@DPU AS NUMERIC(10,2)), GETDATE(), 0)    
      END 
  </code></pre>
  <p>However when I try to create the stored procedure - I get the following error:</p>
  <blockquote>
  <p>The object name 'SQL05.ManufacturingPortal.dbo.OPC.WriteRequests' contains more than the maximum number of prefixes. The maximum is 3.</p>
  </blockquote>
  <p>I have tried creating an alias of Server.DB.DBO to shorten the number of prefixes however seem to be implementing this wrong.</p>
  <p>I cannot change my database schema on the target database. Any suggestions on how I can get around this?</p>
  <p>Thanks</p>