Index warning when updating database #830

easyest created 8 years ago

When executing migration

201602021344016_Added_BackgroundJobs_And_Notifications

there is a warning:

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

I am using SQL Server 2012.

2 Answer(s)

0

daws created 8 years ago

It was resolved with 0.8.1 (<a class="postlink" href="https://github.com/aspnetboilerplate/aspnetboilerplate/issues/864">https://github.com/aspnetboilerplate/as ... issues/864</a> ) did you get the latest nuget version ? ;)
0

easyest created 8 years ago

Yes. I see the index is recreated in the last migration. Topic closed.

Have an answer to this question? Log in and write your answer.