Base solution for your next web application
Starts in:
01 DAYS
01 HRS
01 MIN
01 SEC
Open Closed

Index warning when updating database #830


User avatar
0
easyest created

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)
  • User Avatar
    0
    daws created

    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 ? ;)

  • User Avatar
    0
    easyest created

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