Hey,
Just came across the same error and realised a had a 'SET DATEFIRST' after the cursor was decalred. Moved this to the top of the SP and and now it works no problems.
Had a look on the microsoft site and they suggested upgrading to SP2 for SQL 2005 so might be worth trying that too.
Hope that helps! 🙂