SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create Table Test(Id Int primary key,ProdName Nvarchar(2000))
INSERT INTO Test VALUES (1, REPLICATE('0123456789',45));
1 rows affected

Create index ix_Test ON Test(ProdName);
Warning! The maximum key length is 900 bytes. The index 'ix_Test' has maximum length of 4000 bytes. For some combination of large values, the insert/update operation will fail.


INSERT INTO Test VALUES (2, REPLICATE('0123456789',46));
Msg 1946 Level 16 State 3 Line 1
Operation failed. The index entry of length 920 bytes for the index 'ix_Test' exceeds the maximum length of 900 bytes.