Artoo22 (10/30/2012)
matt.gyton (10/30/2012)
Just a bit more info for you....The database was being transferred from a SQL 2005 server to a SQL 2008 R2 server. I have now determined, after trying it out on several servers, that it appears to only be a problem when the database is restored onto the SQL 2008 R2 servers.
Don't know if that might give any clues?
Have you rebuilt indexes or updated stats?
Matt did say in his first post that he had rebuilt/the indexes and run an update stats.
_________________________________________________________________________
SSC Guide to Posting and Best Practices