SQL Server Errors or Failures from Error: 8179 to Error: 8302



Error: 8179, Severity: 16, Could not find prepared statement with handle %d.
Error: 8180, Severity: 16, Statement(s) could not be prepared.
Error: 8181, Severity: 16, Text for ‘%.*ls’ is missing from the system catalog. The object must be dropped and re-created before it can be used.
Error: 8183, Severity: 16, Only UNIQUE or PRIMARY KEY constraints can be created on computed columns, while CHECK, FOREIGN KEY, and NOT NULL constraints require that computed columns be persisted.
Error: 8184, Severity: 16, Error in binarychecksum. There are no comparable columns in the binarychecksum input.

Error: 8185, Severity: 16, Error expanding “*”: An incomparable column has been found in an underlying table or view.
Error: 8186, Severity: 16, Function ‘%.*ls’ can be used only on user and system tables.
Error: 8187, Severity: 16, The prepared handle %d is currently being used by another command (error state: %d).
Error: 8188, Severity: 16, There is already a SQL type for assembly type “%.*ls” on assembly “%.*ls”. Only one SQL type can be mapped to a given assembly type. CREATE TYPE fails.
Error: 8189, Severity: 16, You do not have permission to run ‘%ls’.
Error: 8190, Severity: 16, Cannot compile replication filter procedure without defining table being filtered.

Error: 8191, Severity: 16, Replication filter procedures can only contain SELECT, GOTO, IF, WHILE, RETURN, and DECLARE statements.
Error: 8192, Severity: 16, Replication filter procedures cannot have parameters.
Error: 8193, Severity: 16, Cannot execute a procedure marked FOR REPLICATION.
Error: 8195, Severity: 16, Cannot create “%.*ls” on “%.*ls”. Insert, Update, and Delete triggers can only be created on user tables and views.
Error: 8196, Severity: 16, Duplicate column specified as ROWGUIDCOL.
Error: 8197, Severity: 16, The object ‘%.*ls’ does not exist or is invalid for this operation.
Error: 8199, Severity: 16, In EXECUTE , procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.
Error: 8301, Severity: 10, Use of level0type with value ‘USER’ in procedure sp_addextendedproperty, sp_updateextendedproperty and sp_dropextendedproperty and in table-valued function fn_listextendedproperty has been deprecated and will be removed in a future version of SQL Server.
Error: 8302, Severity: 10, CREATE RULE and DROP RULE will be removed in a future version of SQL Server. Avoid using CREATE RULE and DROP RULE in new development work, and plan to modify applications that currently use them. Use check constraints instead, which are created using the

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *