Server Error Messages 2700–2799

Number	Severity	Text and Explanation
2701	10	Database name `%.s' ignored, creating table in Tempdb. Explanation:* This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
2702	16	Database `%.s' does not exist. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2703	16	Segment `%.s' does not exist. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2705	16	Column names in each table must be unique. Column name `%.s' in table `%.s' is specified more than once. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2706	11	Table `%.s' does not exist. Explanation:* Command failed. Check your database for the object not found and re-enter the command with the correct name.
2710	16	You are not the owner specified for the object named `%.s' in this command (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS, or BULK INSERT). The database owner can use the SETUSER command to assume the identity of another user. Explanation:* Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
2714	16	There is already an object named `%.s' in the database. Explanation:* Refer to the writeup for this error.
2715	16	Can't find type '%.s'. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2716	16	Can't specify a length or scale on type '%.s'. Explanation:* Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
2717	16	Specified length is too large for type '%.s'. Explanation:* Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
2718	16	Column or parameter #%d: -- can't specify Null values on a column of type BIT. Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
2719	14	You must be the owner of table '%.s' or a System Administrator to update the table's statistics. Explanation:* You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
2721	11	Could not find a default segment to create the table on. Contact a user with System administrator (SA) role to specify a default segment in syssegments. Explanation: Command failed. Check syntax and your Adaptive Server environment.
2724	10	Parameter `%.s' has an invalid data type. Explanation:* An invalid datatype was specified for a table column or stored procedure parameter when creating the object. Check SQL syntax.
2727	11	Cannot find index `%.s'. Explanation:* Command failed. Check your database for the object not found and re-enter the command with the correct name.
2728	21	Could not find sysobjects row for table `%.s'. Explanation:* Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.
2729	16	Procedure `%.s' group number 1 already exists in the database. Choose another procedure name or procedure number. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2730	11	Cannot create procedure `%.s' with a group number of %d because a procedure with the same name and a group number of 1 does not currently exist in the database. Must CREATE PROCEDURE `%.s';1 first. Explanation: Command failed. Check your database for the object not found and re-enter the command with the correct name.
2731	16	Column or parameter #%d: -- can't specify column width of zero for `%.s'. Explanation:* Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
2732	16	User error number %ld is invalid. Number must be between %d and %d. Explanation: SQL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2734	16	User name %.s does not exist in sysusers. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2735	16	Object text is too long. Please shorten the object text or split into multiple objects. Text which caused overflow starts at: ’%.s’. Explanation:* Adaptive Server could not perform the requested action. Determine the maximum text size using the information in the message, and use one of the recommended options to correct the problem.
2736	16	Owner name that was specified is a group name. Objects cannot be owned by groups. Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2737	16	Message passed to %s must be of type CHAR or VARCHAR. Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2738	16	A table can only have one timestamp column. Since table `%.s' already has one, you can't add the column `%.s'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2739	16	TEXT and IMAGE datatypes are invalid for parameters or local variables. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2740	16	SET LANGUAGE failed because `%.s' is not an official language name or a language alias on this SQL Server. Explanation:* Command failed. Use sp_helplanguage and see the Adaptive Server Reference Manual for help with language maintenance.
2741	16	SET DATEFORMAT date order `%.s' is invalid. Explanation:* Command failed. See the Adaptive Server Reference Manual for help with dateformat.
2742	16	SET DATEFIRST %d is out of range. Explanation: Command failed. See the Adaptive Server Reference Manual for help with datefirst.
2743	16	%s command requires %S_MSG parameter. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2744	16	Index distribution page was %ld, now %ld. Perhaps another UPDATE STATISTICS command is currently running. Retry your command. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2745	16	%s command is missing an argument position specifier. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2746	16	Duplicate position specifier in format string of %s command. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2747	16	Incorrect position specifier in format string of %s command. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2748	16	Message number %ld, passed to RAISERROR, does not exist in the %s catalog. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2749	16	Number of argument position specifiers in %s command is greater than the number of arguments passed. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2750	16	Can not have more than %d arguments in a call to %s. Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2751	16	%s command failed because the resulting string exceeded the maximum length of %d bytes. Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2752	20	The PRINT/RAISERROR function received an illegal datatype of `%s'. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.
2753	20	Received an error code of `%d' from `intl_strblist()'. Explanation: Refer to the writeup for Error 2753.
2754	16	There is an argument position specifier that is out of range in a call to %s. Valid argument position specifiers must be in the range from 1 to %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2756	16	Specified type precision %d more than the maximum precision %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
2757	16	Specified scale %d more than the specified precision %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2758	16	Resdom says that column or parameter has no arguments but the length is non-zero. Given length %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2759	10	Internal error: illegal tree encountered. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator.
2760	10	Column name `%.s' does not exist in target 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.
2761	10	Failed to create declarative constraints on table `%.s' in database `%.s'. Explanation: There may be a potential problem with a database or database object. Contact your System Administrator.
2762	16	The `%s' command is not allowed within a multi-statement transaction in the `%.s' database. Explanation:* QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2763	16	An attempt to grant CREATE TABLE permission to PUBLIC in tempdb failed. Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
2764	16	Identity field `%.s' must be a numeric with a scale of 0 and not null allowed. Explanation:* QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2765	16	A table can only have one identity column. Since table `%.s' already has one, you can't add the column `%.s'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2766	16	Cannot use logsegment to create a user table or an index. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2767	16	The table with id=<%ld> in dbid=<%d> does not exist. It may have been created in a concurrently running transaction that rolled back and is now inaccessible. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2768	16	SET label (CURREAD, CURWRITE) failed because new value is an invalid label, or new value doesn't satisfy the dominance relationships among session labels. Explanation: An invalid label was encountered in `set curread' or `set curwrite' command.
2769	16	Invalid maxhold label specified for the table. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2770	16	Invalid minhold label specified for the table. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2771	16	Invalid hold label specified. A table's maxhold label should always dominate it's minhold label. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2772	16	Invalid hold label specified. Only labels below your @@maxwrite are acceptable. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2773	16	Invalid hold label specified. Only labels above your @@minwrite are acceptable. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2774	16	Hold label provided is above database maxhold. Please provide a label below the database maxhold. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2775	20	Object is not a table, or table has NULL maxhold and/or minhold value. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.
2776	16	The `set update_mode' command only takes in a CHAR or VARCHAR argument. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2777	16	Invalid update_mode provided. The only allowable update modes are: reclassify, over_range, and standard. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2778	12	The object `%.s' is not a table. Update statistics can be used only on user tables or system tables Explanation:* UPDATE STATISTICS can only be run on a table. The operation is illegal for other objects.
2779	20	Lock request count has overrun the lock request array boundary. This is an internal error. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.
2780	20	maxlen (%d) is less than length (%d) Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.
2781	18	Internal Error. Master to DB SLID conversion failed. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
2782	16	An untyped variable in the PREPARE statement `%.s' is being resolved to a TEXT or IMAGE type. This is illegal in a dynamic PREPARE statement. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2783	14	The user's curwrite needs to be at the table's hurdle when updating a table's statistics. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
2784	18	Internal row labeling error occured. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
2786	16	MAX_ROWS_PER_PAGE value of %d is invalid. It must be between 0 and %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2787	16	Cache, %s, cannot be found in sysconfigures. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2790	16	Setting maximum online engines to %d causes number of engine freelocks (%d) to fall below half the value of freelock transfer block size (%d). Please increase maximum engine freelocks to %d and reattempt this command. Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
2792	16	Cannot change curread label with open cursors. Please contact a user with System Security Officer (SSO) role for help. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2793	16	User error number %ld is of invalid type. Number must be an integer. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
2794	16	SET PROCESS_LIMIT_ACTION { ABORT \| QUIET \| WARNING } failed because '%. s' is not a valid parameter. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. .
2795	10	The value of 'parallel_degree' (`%d') cannot be larger than the value of configuration parameter 'max parallel degree' (`%d'). The value '%d' is used for 'parallel_degree'. Explanation: This is an informational message. No action is required. .
2796	16	The values of 'parallel_degree' and 'scan_parallel_degree' cannot be less than zero. Explanation: Command failed due to invalid or illegal request. .
2797	10	The value of 'parallel_degree' (`%d') cannot be larger than the value of 'parallel_degree' set by a calling procedure. The value '%d' is used. Explanation: This is an informational message. No action required. .
2798	10	The value of 'scan_parallel_degree' (`%d') cannot be larger than the lesser of the configuration parameter 'max scan parallel degree' (`%d') and current 'parallel_degree' (`%d'). The value `%d' is used for 'scan_parallel_degree'. Explanation: This is an informational message. No action required. .