Server Error Messages 6200 - 6299


 STEP %d
 The type of query is SELECT (into Worktable%d).
 The type of query is %s.
 The update mode is direct.
 The update mode is deferred.
 GROUP BY
 Vector Aggregate
 Scalar Aggregate
 This step involves sorting.
Worktable%d created, in %s locking mode, for ORDER BY.
Worktable%d created, in %s locking mode, for DISTINCT.
 Worktable%d created for REFORMATTING.
 Worktable%d created for SELECT_INTO.
 TO TABLE
 FROM TABLE
 Worktable%d.
 %.*s
 DISJOINT TABLE : nested iteration.
Nested iteration.
EXISTS TABLE : nested iteration.
 Using GETSORTED
 Using Dynamic Index.
 Table Scan.
 Using Clustered Index.
 Index : %.*s
 Index name not found.
 Log Scan.
 Cursor name `%.*s' is declared on procedure `%.*s'.
 Cursor name `%.*s' is declared at nesting level `%d'.
 The cursor is positioned after the last row.
 The current cursor position has been deleted.
 The cursor is positioned before the next row.
 The cursor is positioned on a row.
 There have been %d rows read, %d rows updated and %d rows deleted through this cursor.
 The cursor is not open.
 The cursor will be closed if the current position is deleted.
 The cursor will be closed when a transaction is committed or rolled back.
 The cursor will remain open when a transaction is committed or rolled back.
 The number of rows returned for each FETCH is %d.
 The cursor is read only.
 The cursor is updatable.
 There are %d columns returned by this cursor.
The result columns are:
 Name = `%.*s', `Expression Result', Type = %s, Length = %d (%S_MSG)
 Name = `%.*s', Table = `%.*s', Type = %s, Length = %d (%S_MSG)
The cursor was opened with these parameters:
%s
 There are no active cursors.
 There are no active cursors that match the search criteria.
 This cursor is declared within a stored procedure. The cursor's memory usage cannot be distinguished from that of the procedure as a whole.
 This cursor is declared on a stored procedure. It is presently using `%d' bytes. However, the memory usage will increase when the cursor is opened because the query plan will be associated with the cursor at that time.
 This cursor is declared on a stored procedure. It is using %ld bytes of memory.  The procedure's plan (%ld bytes) will be returned to the procedure cache when the cursor is closed.
 This cursor is using %ld bytes of memory.
 The cursor id is %ld.
 The cursor has been successfully opened %d times.
 The cursor was closed by a CLOSE CURSOR statement.
 The cursor was closed because its current scan position could not be maintained following a delete, update or insert.
 The cursor was closed because it was declared on a join and its current position was deleted.
 The cursor was closed due to an error on the OPEN CURSOR statement.
 The cursor was closed because CLOSE ON ENDTRAN was SET ON and the transaction containing the cursor ended.
 The cursor is read only because it is declared on a union.
 The cursor is read only because it is declared on a group by or its plan includes a group by operation.
 The cursor is read only because it contains a DISTINCT.
 The cursor is read only because it contains an aggregate.
 The cursor is read only because it contains an ORDER BY clause.
 Showplan output for the cursor:
 The cursor is currently scanning at isolation level 0.
 The cursor is currently scanning at a nonzero isolation level.
 The cursor was compiled at isolation level %d.
Using I/O Size %d Kbytes for index leaf pages. 
With %S_MSG Buffer Replacement Strategy for index leaf pages. 
 Evaluate Grouped %s.
 Evaluate Ungrouped %s.
 Forward scan.
 Backward scan.
 Positioning at start of table.
 Positioning at end of table.
 Positioning by Row IDentifier (RID).
 Positioning by key.
 Positioning at index start.
 Positioning at index end.
 Scanning only the last page of the table.
 Scanning only up to the first qualifying row.
 Index contains all needed columns. Base table will not be read.
 Keys are:
 %.*s %S_MSG
 QUERY PLAN FOR STATEMENT %u (at line %u).
 MRU
 LRU
 Using %d Matching Index Scans

Number	Severity	Text and Explanation
6201	10	STEP %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.
6202	10	The type of query is SELECT (into Worktable%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.
6203	10	The type of query 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.
6204	10	The update mode is direct. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6205	10	The update mode is deferred. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6206	10	GROUP BY Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6207	10	Vector Aggregate Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6208	10	Scalar Aggregate Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6209	10	This step involves sorting. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6210	10	Worktable%d created, in %s locking mode, for ORDER BY. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6211	10	Worktable%d created, in %s locking mode, for DISTINCT. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6212	10	Worktable%d created for REFORMATTING. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6213	10	Worktable%d created for SELECT_INTO. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6214	10	TO 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.
6215	10	FROM 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.
6216	10	Worktable%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.
6217	10	%.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.
6218	10	DISJOINT TABLE : nested iteration. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6219	10	Nested iteration. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6220	10	EXISTS TABLE : nested iteration. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6221	10	Using GETSORTED Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6222	10	Using Dynamic 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.
6223	10	Table Scan. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6224	10	Using Clustered 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.
6225	10	Index : %.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.
6226	10	Index name 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.
6227	10	Log Scan. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6228	10	Cursor name `%.s' is declared on procedure `%.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.
6229	10	Cursor name `%.s' is declared at nesting level `%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.
6230	10	The cursor is positioned after the last row. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6231	10	The current cursor position has been deleted. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6232	10	The cursor is positioned before the next row. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6233	10	The cursor is positioned on a row. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6234	10	There have been %d rows read, %d rows updated and %d rows deleted through 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.
6235	10	The cursor is not open. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6236	10	The cursor will be closed if the current position is deleted. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6237	10	The cursor will be closed when a transaction is committed or rolled back. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6238	10	The cursor will remain open when a transaction is committed or rolled back. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6239	10	The number of rows returned for each FETCH is %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.
6240	10	The cursor is read only. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6241	10	The cursor is updatable. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6242	10	There are %d columns returned by 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.
6243	10	The result columns are: Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6245	10	Name = `%.s', `Expression Result', Type = %s, Length = %d (%S_MSG) Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6246	10	Name = `%.s', Table = `%.s', Type = %s, Length = %d (%S_MSG) Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6247	10	The cursor was opened with these parameters: Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6248	10	%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.
6249	10	There are no active cursors. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6250	10	There are no active cursors that match the search criteria. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6251	10	This cursor is declared within a stored procedure. The cursor's memory usage cannot be distinguished from that of the procedure as a whole. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6252	10	This cursor is declared on a stored procedure. It is presently using `%d' bytes. However, the memory usage will increase when the cursor is opened because the query plan will be associated with the cursor at that time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6253	10	This cursor is declared on a stored procedure. It is using %ld bytes of memory. The procedure's plan (%ld bytes) will be returned to the procedure cache when the cursor is closed. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6254	10	This cursor is using %ld bytes of memory. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6255	10	The cursor id is %ld. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6256	10	The cursor has been successfully opened %d times. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6257	10	The cursor was closed by a CLOSE CURSOR statement. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6259	10	The cursor was closed because its current scan position could not be maintained following a delete, update or insert. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6260	10	The cursor was closed because it was declared on a join and its current position was deleted. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6261	10	The cursor was closed due to an error on the OPEN CURSOR statement. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6262	10	The cursor was closed because CLOSE ON ENDTRAN was SET ON and the transaction containing the cursor ended. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6263	10	The cursor is read only because it is declared on a union. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6264	10	The cursor is read only because it is declared on a group by or its plan includes a group by operation. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6265	10	The cursor is read only because it contains a DISTINCT. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6266	10	The cursor is read only because it contains an aggregate. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6267	10	The cursor is read only because it contains an ORDER BY 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.
6268	10	Showplan output for the 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.
6269	10	The cursor is currently scanning at isolation level 0. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6270	10	The cursor is currently scanning at a nonzero isolation level. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
6271	10	The cursor was compiled at isolation level %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.
6272	10	Using I/O Size %d Kbytes for index leaf pages. Explanation: This is an informational message or a message header. No action is required.
6273	10	With %S_MSG Buffer Replacement Strategy for index leaf pages. Explanation: This is an informational message or a message header. No action is required.
6274	10	Evaluate Grouped %s. Explanation: This is an informational message or a message header. No action is required.
6275	10	Evaluate Ungrouped %s. Explanation: This is an informational message or a message header. No action is required.
6276	10	Forward scan. Explanation: This is an informational message or a message header. No action is required.
6277	10	Backward scan. Explanation: This is an informational message or a message header. No action is required.
6278	10	Positioning at start of table. Explanation: This is an informational message or a message header. No action is required.
6279	10	Positioning at end of table. Explanation: This is an informational message or a message header. No action is required.
6280	10	Positioning by Row IDentifier (RID). Explanation: This is an informational message or a message header. No action is required.
6281	10	Positioning by key. Explanation: This is an informational message or a message header. No action is required.
6282	10	Positioning at index start. Explanation: This is an informational message or a message header. No action is required.
6283	10	Positioning at index end. Explanation: This is an informational message or a message header. No action is required.
6284	10	Scanning only the last page of the table. Explanation: This is an informational message or a message header. No action is required.
6285	10	Scanning only up to the first qualifying row. Explanation: This is an informational message or a message header. No action is required.
6286	10	Index contains all needed columns. Base table will not be read. Explanation: This is an informational message or a message header. No action is required.
6287	10	Keys are: Explanation: This is an informational message or a message header. No action is required.
6288	10	%.s %S_MSG Explanation:* This is an informational message or a message header. No action is required.
6289	10	QUERY PLAN FOR STATEMENT %u (at line %u). Explanation: This is an informational message or a message header. No action is required.
6290	10	MRU Explanation: This is an informational message or a message header. No action is required.
6291	10	LRU Explanation: This is an informational message or a message header. No action is required.
6292	10	Using %d Matching Index Scans Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.