December 16, 2025 at 12:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 16, 2025 at 5:28 pm
Before you all add now 16 other columns to your PK, please remind that you still must not have more than 900 bytes in a clustered index 🙂
Clustered Index:
Msg 1944, Level 16, State 1, Line 143
Index 'iuc_PKTest__xxx' was not created because the index key size is at least 2892 bytes. The clustered index key size cannot exceed 900 bytes. If the index key includes implicit key columns, the index key size cannot exceed 2600 bytes.
Nonclustered Index
Msg 1944, Level 16, State 1, Line 124
Index 'iunc_PKTest__xxx' was not created because the index key size is at least 2892 bytes. The nonclustered index key size cannot exceed 1700 bytes. If the index key includes implicit key columns, the index key size cannot exceed 2600 bytes.
God is real, unless declared integer.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply