title: Problem with NOLOCK on SQL 2008 using a temporary table and select statements
body: <p>I am using SQL 2008 and I am getting an error most of the time I run a stored procedure. There error is: <code>could not continue scan with nolock due to data movement</code>. I have looked online for this and it seems that most people get this when updating their SQL version or when doing updates/deletes. I am not doing either. Also the solution seems to be to remove the NOLOCK yet I am not using NOLOCK (unless it is default in SQL Server 2008). I have also tried to insert <code>SET TRANSACTION ISOLATION LEVEL READ uncommitted</code> yet it hasn't made any changes. </p>
  
  <p>My stored procedure consists of getting parameters, creating a temporary table, filling the table with SELECT statements only and then fetching information from the table.</p>
  
  <p>Does anyone know what is wrong?</p>