Home Forums SQL Server 2005 SQL Server 2005 General Discussion A severe error occurred on the current command.The results, if any, should be discarded. RE: A severe error occurred on the current command.The results, if any, should be discarded.

  • September 4, 2011 at 9:18 pm

    #1376935

    Hi there,

    I have seen the same issue on my production box.

    The problems looks like SQL Server works incorrectly with several sub-queries using <> on NOT IN expressions.

    There is a workaround. You can use JOINs instead of sub-queries in order to overcome this issue.