SQL AGENT JOB FAILURE [SQLSTATE 42000] (Error 8623) RRS feed

  • Question

  • Hi all,

    The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information. [SQLSTATE 42000] (Error 8623).


    alternatively Im running a package in that particular step any guesses why would this happen?

    this is an issue after the migration  to new server 2012.

    Tuesday, February 19, 2013 2:24 PM