Issue: "Warning! The maximum key length is 900 bytes" is seen when executing CreateDB.sql script.

Applies to:

Microsoft SQL Server 2008 R2 Express Edition
Microsoft SQL Server 2008 R2 Standard Edition
Microsoft SQL Server 2008 R2 Enterprise Edition
Venafi Encryption Director 7.0

Symptom:

The following warning is seen when executing the CreateDB.sql script using MSSQL 2008 R2.

Warning! The maximum key length is 900 bytes. The index 'config_objects_Parent_Name' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.

Resolution:

This warning is expected. The code ensures we will never enter something in this row exceeding 900 bytes. This warning was exposed when we changed the data type from varchar to nvarchar to allow us to properly store internationalized characters.