title: Migrating database from SQL Server 2005 to 2012
body: <p>Apologies for the vague question but I am having some trouble</p>
  
  <p>I am in progress of migrating databases from SQL Server 2005 (running on XP) to 2012 (running on server 2012) and have hit some trouble. I have unmounted from 2005 and then re-mounted in 2012. I ran the only stored procedure associated with the database on the 2012 box and it fails with the following error</p>
  
  <blockquote>
    <p>A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)</p>
  </blockquote>
  
  <p>If I run the stored procedure on 2005 it works fine and is done in 10 seconds.</p>
  
  <p>Is there anything I should consider before I move the databases.</p>
  
  <p>If you need more info please ask, I didn't display the stored procedure here because I believe its not to do with the stored procedure.</p>