SQL Server Errors or Failures Error: 1763 to Error: 1785

SQLServerF1

 

Error: 1763, Severity: 16,
Cross-database foreign key references are not supported. Foreign key ‘%.*ls’.

Error: 1764, Severity: 16,
Computed Column ‘%.*ls’ in table ‘%.*ls’ is invalid for use in ‘%ls’ because it is not persisted.

Error: 1765, Severity: 16,
Foreign key ‘%.*ls’ creation failed. Only NO ACTION and CASCADE referential delete actions are allowed for referencing computed column ‘%.*ls’.

Error: 1766, Severity: 16,
Foreign key references to temporary tables are not supported. Foreign key ‘%.*ls’.

Error: 1767, Severity: 16,
Foreign key ‘%.*ls’ references invalid table ‘%.*ls’.

Error: 1768, Severity: 16,
Foreign key ‘%.*ls’ references object ‘%.*ls’ which is not a user table.

Error: 1769, Severity: 16,
Foreign key ‘%.*ls’ references invalid column ‘%.*ls’ in referencing table ‘%.*ls’.

Error: 1770, Severity: 16,
Foreign key ‘%.*ls’ references invalid column ‘%.*ls’ in referenced table ‘%.*ls’.

Error: 1771, Severity: 16,
Cannot create foreign key ‘%.*ls’ because it references object ‘%.*ls’ whose clustered index ‘%.*ls’ is disabled.

Error: 1772, Severity: 16,
Foreign key ‘%.*ls’ is not valid. A system table cannot be used in a foreign key definition.

Error: 1773, Severity: 16,
Foreign key ‘%.*ls’ has implicit reference to object ‘%.*ls’ which does not have a primary key defined on it.

Error: 1774, Severity: 16,
The number of columns in the referencing column list for foreign key ‘%.*ls’ does not match those of the primary key in the referenced table ‘%.*ls’.

Error: 1775, Severity: 16,
Cannot create foreign key ‘%.*ls’ because it references object ‘%.*ls’ whose PRIMARY KEY index ‘%.*ls’ is disabled.

Error: 1776, Severity: 16,
There are no primary or candidate keys in the referenced table ‘%.*ls’ that match the referencing column list in the foreign key ‘%.*ls’.

Error: 1778, Severity: 16,
Column ‘%.*ls.%.*ls’ is not the same data type as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’.

Error: 1779, Severity: 16,
Table ‘%.*ls’ already has a primary key defined on it.

Error: 1781, Severity: 16,
Column already has a DEFAULT bound to it.

Error: 1782, Severity: 16,
Cannot drop index ‘%.*ls’ since a partition scheme is not specified for base data.

Error: 1784, Severity: 16,
Cannot create the foreign key ‘%.*ls’ because the referenced column ‘%.*ls.%.*ls’ is a non-persisted computed column.

Error: 1785, Severity: 16,
Introducing FOREIGN KEY constraint ‘%.*ls’ on table ‘%.*ls’ may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

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.

Thanks,
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 *