In my company, somebody wrote stored procedure that works with MSDE and doesnt work with sql server 2008R2. With 2000 it takes few seconds and with 2008 there is a timeout after 600 seconds.
This is a part where I isolated the problem:
(SELECT TOP 1 MovementHeaderId
FROM MovementHeader )
AND DocmentReferenceCode = cast(RetailTransactionLineItemExtended.TransactionOriginalTransactionID as varchar(20)) +'/'+ cast (Ordinal as varchar(20) ))
View Complete Post