• I hope you are using a SCROLL SURSOR remove the scroll keyword and check if the sql executes to success.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com