SQL Server Helper - Error Message 8001 to 8500

Tip of the Day : SQL Server Database Design - Twitter Profile and Followers

Home > Tips & Tricks > Error Messages 8001 to 8500

SQL Server Error Messages - Errors 8001 to 8500

SQL Server Error Message - Errors 8001 to 8500

A message number uniquely identifies each error message and the error message text describes the problem. The error message text often includes placeholders for information (such as object names) to be inserted in the error message when it is displayed. Unfortunately, the error message text does not tell you how to solve or work around the problem. In this series of Error Messages list, we will try to provide you with ways on how to overcome or work around certain error messages.

Some error messages are self-explanatory and can easily be fixed, such as "Invalid object name". Others are harder to fix or work around, especially by those who are new to SQL Server. It is the intent of this page and succeeding pages (to come) to assist you in addressing or working around SQL Server error messages.

Error	Severity	Description
8101	16	An explicit value for the identity column in table "Table Name" can only be specified when a column list is used and IDENTITY_INSERT is ON. s
8102	16	Cannot update identity column "Column Name".
8103	16	Table '%.*ls' does not exist or cannot be opened for SET operation.
8104	16	The current user is not the database or object owner of table '%.*ls'. Cannot perform SET operation.
8105	16	'%.*ls' is not a user table. Cannot perform SET operation.
8106	16	Table '<Table Name>' does not have the identity property. Cannot perform SET operation.
8107	16	IDENTITY_INSERT is already ON for table '<Table Name>'. Cannot perform SET operation for table '%.*ls'.
8108	16	Cannot add identity column, using the SELECT INTO statement, to table '<Table Name>', which already has column '<Column Name>' that inherits the identity property.
8109	16	Attempting to add multiple identity columns to table '%.*ls' using the SELECT INTO statement.
8110	16	Cannot add multiple PRIMARY KEY constraints to table '<Table Name>'.
8111	16	Cannot define PRIMARY KEY constraint on nullable column in table '<Table Name>'.
8112	16	Cannot add more than one clustered index for constraints on table '%.*ls'.
8114	16	Error converting data type %ls to %ls.
8115	16	Arithmetic overflow error converting numeric to data type numeric. Arithmetic overflow error converting numeric to data type varchar.
8116	16	Argument data type %ls is invalid for argument %d of %ls function.
8117	16	Operand data type %ls is invalid for %ls operator.
8118	16	Column '%.ls.%.ls' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
8119	16	Column '%.ls.%.ls' is invalid in the HAVING clause because it is not contained in an aggregate function and there is no GROUP BY clause.
8120	16	Column '%.ls.%.ls' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
8121	16	Column '%.ls.%.ls' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.
8122	16	Only the first query in a UNION statement can have a SELECT with an assignment.
8123	16	A correlated expression is invalid because it is not in a GROUP BY clause.
8124	16	Multiple columns are specified in an aggregated expression containing an outer reference. If an expression being aggregated contains an outer reference, then that outer reference must be the only column referenced in the expression.
8125	16	An aggregated expression containing an outer reference must be contained in either the select list, or a HAVING clause subquery in the query whose FROM clause contains the table with the column being aggregated.
8126	16	Column name '%.ls.%.ls' is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause.
8127	16	Column name '%.ls.%.ls' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
8128	10	Using '%s' version '%s' to execute extended stored procedure '%s'.
8129	16	The new disk size must be greater than %d. Consider using DBCC SHRINKDB.
8130	16	The device is not a database device. Only database devices can be expanded.
8131	10	Extended stored procedure DLL '%s' does not export __GetXpVersion(). Refer to the topic "Backward Compatibility Details (Level 1) - Open Data Services" in the documentation for more information.
8132	10	Extended stored procedure DLL '%s' reports its version is %d.%d. Server expects version %d.%d.
8133	16	None of the result expressions in a CASE specification can be NULL.
8134	16	Divide by zero error encountered.
8135	16	Table level constraint does not specify column list, table '%.*ls'.
8136	16	Duplicate columns specified in %ls constraint key list, table '%.*ls'.
8138	16	Duplicate columns specified in %ls constraint key list, table '%.*ls'.
8139	16	Number of referencing columns in foreign key differs from number of referenced columns, table '%.*ls'.
8140	16	More than one key specified in column level %ls constraint, table '%.*ls'.
8141	16	Column %ls constraint for column '%.ls' references another column, table '%.ls'.
8142	16	Subqueries are not supported in %ls constraints, table '%.*ls'.
8143	16	Parameter '%.*ls' was supplied multiple times.
8144	16	Procedure or function <Procedure of Function Name> has too many arguments specified.
8145	16	%.ls is not a parameter for procedure %.ls.
8146	16	Procedure %.*ls has no parameters and arguments were supplied.
8147	16	Could not create IDENTITY attribute on nullable column '<Column Name>', table '<Table Name>'.
8148	16	More than one column %ls constraint specified for column '%.ls', table '%.ls'.
8149	16	OLE Automation objects are not supported in fiber mode.
8150	16	Multiple NULL constraints were specified for column '%.ls', table '%.ls'.

Error	Severity	Description
8151	16	Both a PRIMARY KEY and UNIQUE constraint have been defined for column '%.ls', table '%.ls'. Only one is allowed.
8152	16	String or binary data would be truncated.
8153	0	Warning: Null value is eliminated by an aggregate or other SET operation.
8154	15	The table '%.*ls' is ambiguous.
8155	15	No column was specified for column <Column Index> of '<Object Name>'.
8156	15	The column '%.ls' was specified multiple times for '%.ls'.
8157	15	All the queries in a query expression containing a UNION operator must have the same number of expressions in their select lists.
8158	15	'<Object Name>' has more columns than were specified in the column list.
8159	15	'<Object Name>' has fewer columns than were specified in the column list.
8160	15	A grouping function can only be specified when either CUBE or ROLLUP is specified in the GROUP BY clause.
8161	15	A grouping function can only be specified when either CUBE or ROLLUP is specified in the GROUP BY clause.
8162	16	Formal parameter '%.*ls' was defined as OUTPUT but the actual parameter not declared OUTPUT.
8163	16	The text, ntext, or image data type cannot be selected as DISTINCT.
8164	16	An INSERT EXEC statement cannot be nested.
8165	16	Invalid subcommand value %d. Legal range from %d to %d.
8166	16	Constraint name '%.*ls' not permitted. Constraint names cannot begin with a number sign (#).
8168	16	Cannot create two constraints named '%.*ls'. Duplicate constraint names are not allowed.
8169	16	Syntax error converting from a character string to uniqueidentifier.
8170	16	Insufficient result space to convert uniqueidentifier value to char.
8171	16	Insufficient result space to convert uniqueidentifier value to char.
8175	10	Could not find table %.*ls. Will try to resolve this table name later.
8176	16	Resync procedure expects value of key '%.*ls', which was not supplied.
8177	16	Cannot use a column in the %hs clause unless it is contained in either an aggregate function or the GROUP BY clause.
8178	16	Prepared statement '%.ls' expects parameter %.ls, which was not supplied.
8179	16	Could not find prepared statement with handle %d.
8180	16	Statement(s) could not be prepared.
8181	16	Text for '%.*ls' is missing from syscomments. The object must be dropped and re-created before it can be used.
8183	16	Only UNIQUE or PRIMARY KEY constraints are allowed on computed columns.
8184	16	Error expanding '': all columns incomparable, '' expanded to zero columns.
8185	16	Error expanding '*': An uncomparable column has been found in an underlying table or view.
8186	16	Function '%.*ls' can be used only on user and system tables.
8190	16	Cannot compile replication filter procedure without defining table being filtered.
8191	16	Replication filter procedures can only contain SELECT, GOTO, IF, WHILE, RETURN, and DECLARE statements.
8192	16	Replication filter procedures cannot have parameters.
8193	16	Cannot execute a procedure marked FOR REPLICATION.
8194	16	Cannot execute a USE statement while an application role is active.
8196	16	Duplicate column specified as ROWGUIDCOL.
8197	16	Windows NT user '%.*ls' does not have server access.
8198	16	Could not obtain information about Windows NT group/user '%ls'.
8199	16	In EXECUTE <procname>, procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.