Showplan Errors (10200s)

No new writeups yet.

10201    10           NESTING LEVEL %u SUBQUERIES FOR STATEMENT %u.
10202    10           %s  QUERY PLAN FOR SUBQUERY %u (at nesting level %u and at line %u).
10203    10           %s   Subquery under an IN predicate.
10204    10           %s   Subquery under an ANY predicate.
10205    10           %s   Subquery under an ALL predicate.
10206    10           %s   Subquery under an EXISTS predicate.
10207    10           %s   Subquery under an EXPRESSION predicate.
10208    10           %s   Correlated Subquery.
10209    10           %s   Non-correlated Subquery.
10210    10           %s  END OF QUERY PLAN FOR SUBQUERY %u.
10211    10           %s  Run subquery %u (at nesting level %u).
10212    10           The cursor is read only because it contains a subquery.
10213    10           %s  The update mode is deferred_varcol.
10214    10           %s  The update mode is deferred_index.
10215    10           There have been %d scan fixups and %d matching search argument fixups for this cursor.
10216    10           The cursor is read only because it is referencing a dynamic table.
10217    10                   Executed by coordinating process.
10218    10           Executed in parallel by coordinating process and %d worker processes.
10219    10           Executed in parallel by %d worker processes.
10220    10           %s Executed in parallel with a %d-way partition scan.
10221    10           Executed in parallel by coordinating process and %d worker processes.
10222    10                   Parallel work table merge.
10223    10                   Parallel network buffer merge.
10224    10                   Parallel result buffer merge.
10225    10           Auxiliary scan descriptors required: %d
10226    10           The specified spid value '%d' is out of range. It must be positive and not exceed the maximum number of user connections.
10227    10           There is no active server process for the specified spid value '%d'.  Possibly the user connection has terminated.
10228    10           The specified spid value '%d' applies to a server internal process, which does not execute a query plan.
10229    10           The process with the specified spid value '%d' has not been assigned an sqltext structure.  Query plan retrieval cannot continue.
10230    10           The query plan for spid '%d' is unavailable. Possibly the query has not started or has finished executing.
10231    10           The current batch id '%u' does not match the specified batch id '%d'. Specify just the spid value to obtain the current batch id.
10232    10           The current context id '%d' does not match the specified context id '%d'. Specify just the spid value to obtain the current context id.
10233    10           The specified statement number '%d' is greater than the number of statements in the batch or procedure. Specify just the spid value to obtain the current statement number.
10234    10           The SQL batch contains '%d' bytes. Text is '%.*s'.
10235    10           The cursor was closed because the object associated with it has been dropped.
10236    10           Executed by %d worker processes.
10237    10           %s Executed in parallel with a %d-way hash scan.
10239    10           %s  With %S_MSG Buffer Replacement Strategy for data pages.
10240    10           %s  Using I/O Size %d Kbytes for data pages.
10241    10           ASC
10242    10           DESC
10243    10                   Index key order not found.
10244    10           Optimized using simulated statistics.
10246    10           Optimized using an Abstract Plan (ID : %d).
10247    10           Optimized using the Abstract Plan in the PLAN clause.
10249    10                   Parallel data merge using %d worker processes.
10250    10                   Worktable%d created for sort merge join.
10251    10                   Merge join (outer table).
10252    10                   Merge join (inner table).
10253    10                   Serial data merge.
10254    10                   Data copying.
10255    10                   Text/Image column(s) deallocation.
10256    10                   Catalog updates.
10257    10                   Executing a newly cached statement (SSQL_ID = %u).
10258    10                   Executing a previously cached statement (SSQL_ID = %u).
10259    10           The cursor was closed because its current scan position could not be maintained following a severe error during a FETCH operation.
10260    10           The cursor is declared as %s cursor.
10261    10           %s  Worktable%d created in %s locking mode.
10262    10                   The type of query is %s.
10263    10           %s Using Worktable%d for internal storage.
10264    10           Optimized using the forced options (internally generated Abstract Plan).
10265    10           %s If probe succeeds, raise error.
10266    10           %s If probe fails, raise error.
10267    10           %s If probe succeeds, insert into worktable.
10268    10           %s If probe fails, insert into worktable.
10269    10           %s Probe if needed: If probe succeeds, insert into worktable.
10270    10           %s Unknown action.
10271    10           %s External Definition: %.*s
10272    10           %s SERVER: %.*s
10273    10           %s Using Virtually hashed index.
10274    10           QUERY PLAN FOR SQL UDF %s :
10275    10           END OF QUERY PLAN FOR SQL UDF %s .
10276    10           QUERY PLAN IS RECOMPILED DUE TO %s.
10277    10           THE RECOMPILED QUERY PLAN IS:
10278    10           Optimized using Deferred Compilation.
10279    10           To be Optimized at runtime using Deferred Compilation.
10280    10           Optimized at runtime using Deferred Compilation.
10282    10           %s Table (or index) resides in in-memory database.
10283    10           Optimized using %s Mode