Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Practice Test
Tip of the Day : How to Get a List of Databases Within a SQL Server Instance
Home > Tips & Tricks > Error Messages 8001 to 8500
SQL Server Error Messages - 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.

Related Articles :