Page tree
Skip to end of metadata
Go to start of metadata


Documented in 15.7 TSG: 207,208,213,216,225,226,229,232,233,241,247,257,259,265,266,268,277

New Descriptions: 201, 225

Sequencer Errors (200s)

201 *     16           Procedure %.*s expects parameter %.*s, which was not supplied.
202        11           Internal error -- Unable to open table at query execution time.
203        16           The name '%.*s' is not a valid identifier.
204        20           Normalization error; node %s
205        16           All queries in a SQL statement containing set operators must have an equal number of expressions in their target lists.
206        16           Operand type clash: %s is incompatible with %s
207 #     16           Invalid column name '%.*s'.
208 #     16           %.*s not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
209        16           Ambiguous column name %.*s
210        16           Syntax error converting DATETIME from BINARY/VARBINARY string.
211        16           Syntax error converting SMALLDATETIME from BINARY/VARBINARY string.
212        16           Expression result length exceeds maximum: max - %d  found - %d
213 #     16           Insert error: column name or number of supplied values does not match table definition.
214        16           Cannot convert parameter %.*s to type %.*s expected by procedure.
216 #     20           Attempt to automatically drop temporary table failed.
217        16           Maximum stored procedure nesting level exceeded (limit %d). Please use sp_configure to increase the 'max nesting level'.
218        16           Given parameter %.*s is too large; maximum size for this parameter is %d bytes.
219        16           Print format failed to match with a result column.
220        16           Arithmetic overflow error for type %s, value =  %ld.
221        16           Column of type (%s) does not allow nulls. It may not be compared with null.
222        20           Unintelligible query plan step encountered.
223        11           Object %ld specified as a default for tabid %ld, colid %d is missing or not of type default.
224        11           Object %ld specified as a rule/check constraint for tabid %ld, colid %d is missing or not of type default.
225 #*    11           Cannot run query--referenced object (name %.*s) dropped during query optimization.
226 #     16           %s command not allowed within multi-statement transaction.
227        16           Arithmetic overflow error ocurred while converting the string '%.*s' to type %s.
228        14           Query is based on a view that no longer exists (id = %ld)--cannot run.
229 #     14           %s permission denied on object %S_OBJID, database %S_DBID, owner %.*s
230        14           %s permission denied on column %.*s of object %S_OBJID, database %S_DBID, owner %.*s
231        11           Getdefault: no such default. id=%ld dbid=%d
232 #     16           Arithmetic overflow error for type %s, value = %f.
233 #     16           The column %.*s in table %.*s does not allow null values.%S_EED
234        16           There is insufficient result space to convert MONEY value to CHAR.
235        16           Precision error during %S_MSG conversion of %s value '%s' to a %s field.
236        16           The conversion from CHAR to MONEY resulted in a MONEY overflow error.
237        16           There is insufficient result space to convert MONEY value to %s.
238        16           There is insufficient result space to convert %s value (= %d) to MONEY.
239        16           Table '%.*s' does not exist.  Please refer to sysobjects for correct name.
240        16           There is insufficient result space to convert DATETIME value to CHAR.
241 #     16           Scale error during %S_MSG conversion of %s value '%s' to a %s field.
242        16           The conversion of CHAR to DATETIME resulted in a DATETIME value out of range.
243        16           Type '%.*s' is not a defined system type.
244        16           The conversion of CHAR value '%.*s' overflowed an INT1 field, use a larger integer field.
245        16           Domain error during %S_MSG conversion of %s value '%s' to a %s field.
246        16           The conversion of CHAR value '%.*s' overflowed an INT2 field, use a larger integer field.
247 #     16           Arithmetic overflow during %S_MSG conversion of %s value '%s' to a %s field .
248        16           The conversion of CHAR value '%.*s' overflowed an INT4 field. Maximum integer value exceeded.
249        16           Syntax error during %S_MSG conversion of %s value '%s' to a %s field.
251        16           Unable to allocate ancillary table for query optimization.  Maximum number of tables in a query (%d) exceeded.
252        16           Can't group by a bit field.
253        16           Maximum number of group-by expressions exceeded. Limit is %d, found %d aggregate expressions.
254        16           Maximum number of columns in a work table (%d) exceeded.
255        16           Size of row in the worktable for grouped aggregate, %d bytes, exceeds the maximum row size (%d bytes). Cannot run this query.
256        16           The data type '%s' is invalid for the %s function.  Allowed types are: CHAR/VARCHAR and BINARY/VARBINARY.
257 #     16           Implicit conversion from datatype '%s' to '%s' is not allowed.  Use the CONVERT function to run this query.
258        20           Database '%.*s' missing during query recompile.
259 #     16           Ad-hoc updates to system catalogs not enabled. A user with System Security Officer (SSO) role must reconfigure system to allow this.
261        16           '%.*s' is not a recognized global variable.
262        16           %s permission denied, database %S_DBID, owner %.*s
263        16           Must specify table to SELECT * FROM.
264        16           Column name %.*s appears more than once in the result column list.
265 #     16           Insufficient result space for %S_MSG conversion of %s value '%s' to a %s field.
266 #     16           Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = %d, Current count = %ld.
267        16           Object '%.*s' cannot be found.
268 #     16           You can't run SELECT INTO in this database. Please check with the Database Owner.
269        16           NULL value cannot be specified for conversion from datatype '%s' to '%s'.
270        16           Table '%.*s' can't be modified.
272        16           Can't update a TIMESTAMP column.
273        10           Warning: A non-null value cannot be inserted into a TIMESTAMP column by the user. The database timestamp value has been inserted into the TIMESTAMP field instead.
274        20           A SYSTEM exception was raised with an unrecognized minor number %d.
276        16           The parameter '%.*s' in the procedure '%.*s' was not declared as an OUTPUT parameter.
277 #     16           There was a transaction active when exiting the stored procedure '%.*s'. The temporary table '%.*s' was dropped in this transaction either explicitly or implicitly.
                             This transaction has been aborted to prevent database corruption.
278        16           TEXT, IMAGE, UNITEXT and off-row Java datatypes may not be used in a GROUP BY clause.
279        16           TEXT, IMAGE, UNITEXT and off-row Java datatypes are invalid in this subquery or aggregate expression.
280        16           Only columns of TEXT, IMAGE and UNITEXT datatypes are valid with the TEXTPTR function.
281        16           %d is not a valid style number when converting from DATETIME to a character string.
282        10           Procedure '%.*s' attempted to return a status of NULL, which is not allowed.  A status of 0 will be returned instead.
283        16           You can't use browse mode with DBLIB 2.0 -- you must upgrade to DBLIB 4.0 in order to run this query.
284        16           Rules may not be bound to TEXT, IMAGE or UNITEXT datatypes.
285        16           READTEXT and WRITETEXT commands may not be used with views.
286        16           The logical tables INSERTED and DELETED may not be updated.
287        16           %s command not allowed within a trigger.
288        16           The PATINDEX function operates on CHAR, VARCHAR, UNICHAR, UNIVARCHAR, TEXT and UNITEXT datatypes only.
290        16           Trace 3604 is illegal within a stored procedure.
291        16           Access to %s is disallowed.
292        16           There is insufficient result space to convert SMALLMONEY value to CHAR.
293        16           Precomputed result set error: At least one of the base table is owned by a different user; only manual PRS is allowed on table owned by a different user.
294        16           The conversion from CHAR to SMALLMONEY resulted in a SMALLMONEY overflow error.
295        16           Cannot refresh '%.*s' because it is not a %S_MSG.
296        16           The conversion of CHAR to SMALLDATETIME resulted in a SMALLDATETIME value out of range.
297        16           There is insufficient result space to convert SMALLDATETIME value to CHAR.
298        16           The conversion from DATETIME to SMALLDATETIME resulted in a SMALLDATETIME overflow error.
299        16           The symbol '*' can only be used for a subquery select list when the subquery is introduced with EXISTS or NOT EXISTS or the subquery references a single table and column.



  • No labels