SQL Server Errors or Failures Error: 1786 to Error: 1810



Error: 1786, Severity: 16,
Either column ‘%.*ls.%.*ls’ or referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’ is a timestamp column. This data type cannot be used with cascading referential integrity constraints.

Error: 1787, Severity: 16,
Cannot define foreign key constraint ‘%.*ls’ with cascaded DELETE or UPDATE on table ‘%.*ls’ because the table has an INSTEAD OF DELETE or UPDATE TRIGGER defined on it.

Error: 1788, Severity: 16,
Cascading foreign key ‘%.*ls’ cannot be created where the referencing column ‘%.*ls.%.*ls’ is an identity column.

Error: 1789, Severity: 16,
Cannot use CHECKSUM(*) in a computed column, constraint, or default definition.

Error: 1790, Severity: 16,
The name of a user-defined table type cannot start with a number (#) sign.

Error: 1791, Severity: 16,
A DEFAULT constraint cannot be created on the column ‘%.*ls’ in the table ‘%.*ls’ because the column is a sparse column or sparse column set. Sparse columns or sparse column sets cannot have a DEFAULT constraint.

Error: 1792, Severity: 16,
Alter table ‘%.*ls’ failed because the added fixed column might cause existing data to go beyond the maximum allowable table row size of %d bytes.

Error: 1793, Severity: 16,
Cannot federate a temporary table.

Error: 1794, Severity: 16,
Column ‘%.*ls’ is invalid for federating the table ‘%.*ls’.

Error: 1795, Severity: 16,
Nullable column ‘%.*ls’ cannot be used to federate the table ‘%.*ls’.

Error: 1796, Severity: 16,
Computed column ‘%.*ls’ cannot be used to federate the table ‘%.*ls’.

Error: 1797, Severity: 16,
Sparse column ‘%.*ls’ cannot be used to federate the table ‘%.*ls’.

Error: 1798, Severity: 16,
Federated tables cannot be created in a non-federated database.

Error: 1799, Severity: 16,
Column ‘%.*ls’ cannot be used to federate the table ‘%.*ls’ because it does not match the federation key type.

Error: 1801, Severity: 16,
Database ‘%.*ls’ already exists. Choose a different database name.

Error: 1802, Severity: 16,
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Error: 1803, Severity: 17,
The CREATE DATABASE statement failed. The primary file must be at least %d MB to accommodate a copy of the model database.

Error: 1806, Severity: 16,
CREATE DATABASE failed. The default collation of database ‘%.*ls’ cannot be set to ‘%.*ls’.

Error: 1807, Severity: 17,
Could not obtain exclusive lock on database ‘%.*ls’. Retry the operation later.

Error: 1810, Severity: 16,
The model database must be updatable before a new database can be created.

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 *