Reading Gail Shaw’s post All indexes are unique, reminded me of an interesting piece of trivia I discovered back in SQL Server 7. The error message for running out of uniqueifier values is 666.
SELECT TEXT FROM sys.messages WHERE message_id = 666
Returns:
The maximum system-generated unique value for a duplicate group was exceeded for index with partition [...]
