Skip to content

Commit 50da8bf

Browse files
ktaranovktaranov
committed
Add Temporal tables list of errors
1 parent b951b9c commit 50da8bf

1 file changed

Lines changed: 8 additions & 0 deletions

File tree

‎Errors/README.md‎

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -93,6 +93,7 @@ SELECT message_id, severity, text
9393
| 4064 | Cannot open user default database. Login failed.Login failed. … | [4064_link1] |
9494
| 4189 | Cannot convert to text/ntext or collate to '%.*ls' because these legacy LOB types do not support UTF-8 … | [4189_link1][21] |
9595
| 4629 | Permissions on server scoped catalog views or system stored procedures or extended stored … | [4629_link1][12] |
96+
| 4901 | ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition … | [4901_link1][33] |
9697
| 4922 | ALTER TABLE ALTER COLUMN Address failed because one or more objects access this column. … | [4922_link1] |
9798
| 4934 | Computed column '%.*ls' in table '%.*ls' cannot be persisted because the column does user or … | [4934_link1] |
9899
| 4947 | ALTER TABLE SWITCH statement failed. There is no identical index in source table '%.*ls' for the … | [4947_link1][18] |
@@ -122,7 +123,13 @@ SELECT message_id, severity, text
122123
| 9002 | The transaction log for database '%ls' is full due to '%ls'. … | [9002_link1][17],[9002_link2][19] |
123124
| 10314 | An error occurred in the Microsoft .NET Framework while trying to load assembly id %d. The server may … | [10314_link1] |
124125
| 10637 | Cannot perform this operation on '%.*ls' with ID %I64d as one or more indexes are currently in … | [10637_link1][32] |
126+
| 13515 | Setting SYSTEM_VERSIONING to ON failed because history table '%.*ls' has custom unique keys defined. … | [13515_link1][33] |
127+
| 13518 | Setting SYSTEM_VERSIONING to ON failed because history table '%.*ls' has IDENTITY column specification … | [13518_link1][33] |
128+
| 13523 | Setting SYSTEM_VERSIONING to ON failed because table '%.*ls' has %d columns and table '%.*ls' has %d … | [13523_link1][33] |
129+
| 13543 | Setting SYSTEM_VERSIONING to ON failed because history table '%.*ls' contains invalid records with end … | [13543_link1][33] |
125130
| 13570 | The use of replication is not supported with system-versioned temporal table '%s' | [13570_link1] |
131+
| 13573 | Setting SYSTEM_VERSIONING to ON failed because history table '%.*ls' contains overlapping records. | [13573_link1][33] |
132+
| 13575 | ADD PERIOD FOR SYSTEM_TIME failed because table '%.*ls' contains records where end of period is not … | [13575_link1][33] |
126133
| 13901 | Identifier '%.*ls' in a MATCH clause is not a node table or an alias for a node table. | [13901_link1][30] |
127134
| 13902 | Identifier '%.*ls' in a MATCH clause is not an edge table or an alias for an edge table. | [13902_link1][30] |
128135
| 15002 | The procedure 'sys.sp_dbcmptlevel' cannot be executed within a transaction. … | [15002_link1] |
@@ -177,6 +184,7 @@ SELECT message_id, severity, text
177184
[30]:http://www.nikoport.com/2018/12/01/sql-graph-part-iii-derived-tables-views/
178185
[31]:https://www.mssqltips.com/sqlservertip/5971/accelerated-database-recovery-in-sql-server-2019/
179186
[32]:https://www.brentozar.com/archive/2019/03/what-happens-when-you-cancel-or-kill-a-resumable-index-creation/
187+
[33]:https://curiousaboutdata.com/2019/04/15/temporal-tables-list-of-errors-with-reasons/
180188

181189
[Who owns your availability groups?]:http://www.cjsommer.com/2016-10-20-who-owns-your-availability-groups/
182190
[102_link1]:http://jasonbrimhall.info/2017/11/17/incorrect-syntax-what/

0 commit comments

Comments
 (0)