Duplicate keys, foreign key and check conflicts, NULLs in required columns and cascade-path problems.
2627
Violation of PRIMARY KEY / UNIQUE constraintCannot insert a duplicate key into a primary key or unique constraint.
2601
Cannot insert duplicate key row with unique indexA duplicate value broke a unique index (the index version of 2627).
547
Statement conflicted with a FOREIGN KEY or CHECK constraintAn insert, update or delete broke a foreign key or check rule.
515
Cannot insert the value NULL into a NOT NULL columnA required column was left NULL and has no default value.
1785
Introducing FOREIGN KEY may cause cycles or multiple cascade pathsA cascading foreign key (CASCADE or SET NULL) would create a second cascade path or a cycle.
No errors in this category match your search. Search the whole library.
Other categories
- Logins & Permissions 19
- Connectivity 9
- Syntax & Object Resolution 22
- Data Type & Conversion 15
- Concurrency & Locking 2
- Transactions 5
- Log & Storage Space 3
- Backup & Restore 15
- Database State & Recovery 13
- Corruption & Consistency 8
- Memory 6
- Query Processing & Performance 7
- High Availability 8
- SQL Server Agent 4
- Linked Servers 7