Server Error Messages 10200 - 10299


 NESTING LEVEL %u SUBQUERIES FOR STATEMENT %u.
 QUERY PLAN FOR SUBQUERY %u (at nesting level %u and at line %u).
 Subquery under an IN predicate.
 Subquery under an ANY predicate.
 Subquery under an ALL predicate.
 Subquery under an EXISTS predicate.
 Subquery under an EXPRESSION predicate.
 Correlated Subquery.
 Non-correlated Subquery.
 END OF QUERY PLAN FOR SUBQUERY %u.
 Run subquery %u (at nesting level %u).
 The cursor is read only because it contains a subquery.
 The update mode is deferred_varcol.
 The update mode is deferred_index.
 There have been %d scan fixups and %d matching search argument fixups for this cursor.
 The cursor is read only because it is referencing a dynamic table.
Executed by coordinating process.  
Executed in parallel by coordinating process and %ld worker processes.  
Executed in parallel by %ld worker processes.  
Executed in parallel with a %ld-way partition scan.  
Executed in parallel by coordinating process and %ld worker processes.  
Parallel work table merge.  
Parallel network buffer merge.  
Parallel result buffer merge.  
Auxiliary scan descriptors required: %ld 
The specified spid value '%d' is out of range. It must be positive and not exceed the maximum number of user connections. 
There is no active server process for the specified spid value '%d'.  Possibly the user connection has terminated. 
The specified spid value '%d' applies to a server internal process, which does not execute a query plan. 
The process with the specified spid value '%d' has not been assigned an sqltext structure.  Query plan retrieval cannot continue. 
The query plan for spid '%d' is unavailable. Possibly the query has not started or has finished executing.  
The current batch id '%d' does not match the specified batch id '%d'. Specify just the spid value to obtain the current batch id.  
The current context id '%d' does not match the specified context id '%d'. Specify  just the spid value to obtain the current context id. 
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. 
The SQL batch contains '%d' bytes. Text is '%.*s'. 
 The cursor was closed because the object associated with it has been dropped.
Executed by %ld worker processes. 
Executed in parallel with a %ld-way hash scan. 
With %S_MSG Buffer Replacement Strategy for data pages.
Using I/O Size %d Kbytes for data pages. 
ASC 
DESC 
Index key order not found. 
Optimized using simulated statistics.  
Optimized using an Abstract Plan (ID : %d).
Optimized using the Abstract Plan in the PLAN clause.
 Serial data merge.
Parallel data merge using %d worker processes.
Worktable%d created for sort merge join. 
Merge join (outer table).
Merge join (inner table).
Serial data merge.
Data copying.
Text/Image column(s) deallocation.
Catalog updates.

Number	Severity	Text and Explanation
10201	10	NESTING LEVEL %u SUBQUERIES FOR STATEMENT %u. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10202	10	QUERY PLAN FOR SUBQUERY %u (at nesting level %u and at line %u). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10203	10	Subquery under an IN predicate. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10204	10	Subquery under an ANY predicate. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10205	10	Subquery under an ALL predicate. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10206	10	Subquery under an EXISTS predicate. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10207	10	Subquery under an EXPRESSION predicate. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10208	10	Correlated Subquery. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10209	10	Non-correlated Subquery. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10210	10	END OF QUERY PLAN FOR SUBQUERY %u. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10211	10	Run subquery %u (at nesting level %u). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10212	10	The cursor is read only because it contains a subquery. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10213	10	The update mode is deferred_varcol. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10214	10	The update mode is deferred_index. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10215	10	There have been %d scan fixups and %d matching search argument fixups for this cursor. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10216	10	The cursor is read only because it is referencing a dynamic table. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10217	10	Executed by coordinating process. Explanation: This is an informational message or a message header. No action is required.
10218	10	Executed in parallel by coordinating process and %ld worker processes. Explanation: This is an informational message or a message header. No action is required.
10219	10	Executed in parallel by %ld worker processes. Explanation: This is an informational message or a message header. No action is required.
10220	10	Executed in parallel with a %ld-way partition scan. Explanation: This is an informational message or a message header. No action is required.
10221	10	Executed in parallel by coordinating process and %ld worker processes. Explanation: This is an informational message or a message header. No action is required.
10222	10	Parallel work table merge. Explanation: This is an informational message or a message header. No action is required.
10223	10	Parallel network buffer merge. Explanation: This is an informational message or a message header. No action is required.
10224	10	Parallel result buffer merge. Explanation: This is an informational message or a message header. No action is required.
10225	10	Auxiliary scan descriptors required: %ld Explanation: This is an informational message or a message header. No action is required.
10226	10	The specified spid value '%d' is out of range. It must be positive and not exceed the maximum number of user connections. Explanation: This is an informational message or a message header. No action is required.
10227	10	There is no active server process for the specified spid value '%d'. Possibly the user connection has terminated. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10228	10	The specified spid value '%d' applies to a server internal process, which does not execute a query plan. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10229	10	The process with the specified spid value '%d' has not been assigned an sqltext structure. Query plan retrieval cannot continue. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10230	10	The query plan for spid '%d' is unavailable. Possibly the query has not started or has finished executing. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10231	10	The current batch id '%d' does not match the specified batch id '%d'. Specify just the spid value to obtain the current batch id. Explanation: This message is sent when the target process has received a new SQL batch since the user executed sp_showplan.
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. Explanation: This message is sent when the target process has invoked or returned from a procedure since you executed sp_showplan. So the query plan may not correspond to other information retrieved.
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. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10234	10	The SQL batch contains '%d' bytes. Text is '%.s'. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10235	10	The cursor was closed because the object associated with it has been dropped. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10236	10	Executed by %ld worker processes. Explanation: This is an informational message or a message header. No action is required.
10237	10	Executed in parallel with a %ld-way hash scan. Explanation: This is an informational message or a message header. No action is required.
10239	10	With %S_MSG Buffer Replacement Strategy for data pages. Explanation: Displays the buffer replacement strategy selected by the optimizer for the data pages a given table.
10240	10	Using I/O Size %d Kbytes for data pages. Explanation: Displays the I/O size of the data pages selected by the optimizer for a given table.
10241	10	ASC Explanation: This is informational text or header.
10242	10	DESC Explanation: This is informational text or header.
10243	10	Index key order not found. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10244	10	Optimized using simulated statistics. Explanation: This is informational text.
10246	10	Optimized using an Abstract Plan (ID : %d). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10247	10	Optimized using the Abstract Plan in the PLAN clause. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10248	10	Serial data merge. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10249	10	Parallel data merge using %d worker processes. Explanation: This is an informational message or a message header. No action is required.
10250	10	Worktable%d created for sort merge join. Explanation: This is an informational message or a message header. No action is required.
10251	10	Merge join (outer table). Explanation: This is informational text.
10252	10	Merge join (inner table). Explanation: This is informational text.
10253	10	Serial data merge. Explanation: This is informational text or header.
10254	10	Data copying. Explanation: This is informational text or header.
10255	10	Text/Image column(s) deallocation. Explanation: This is informational text.
10256	10	Catalog updates. Explanation: This is informational text.