This project has moved. For the latest updates, please go here.
1
Vote

Max Key Length Issue on installation

description

I just ran the DB installed script on a SQL 2014 Server and got an error at the end that the max key length had been exceeded. I did some research and found out that SQL2008, SQL2012R2 and 2014 have a max key length of 900 Bytes. https://technet.microsoft.com/en-us/library/ms191241%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396

The IX_QuestionAlias index on the vts_tbQuestion table has a key of 1020 due to using two nvarchars.

I've not seen any issues with running with this.

comments

fwsmaster wrote Jul 10, 2015 at 8:17 PM

Hello,

Thank you for reporting and for adding the link. The issue has been there for a while and does not cause immediate problems (so far it can be ignored). It does need to be fixed of course and its appropriate to have it registered as an issue.

Kind regards
SP Coordinator