topic Re: SQL Server and index key size limit of 900 bytes in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sql-server-and-index-key-size-limit-of-900-bytes/m-p/206167#M159297 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for reporting this. However the chance that this becomes an issue is quite small, because tentant ids are often not that large.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Mon, 08 Sep 2014 18:59:32 GMT trademak 2014-09-08T18:59:32Z SQL Server and index key size limit of 900 bytes https://connect.hyland.com/t5/alfresco-archive/sql-server-and-index-key-size-limit-of-900-bytes/m-p/206166#M159296 I just ran a fresh install of a process engine database of version 5.16.1 to a MS Sql Server (2012).&nbsp; The create-engine script ran with the following warning…(1 row(s) affected)(1 row(s) affected)(1 row(s) affected)Warning! The maximum key length is 900 bytes. The index 'ACT_UNIQ_PROCDEF' has maximu Thu, 04 Sep 2014 21:10:31 GMT https://connect.hyland.com/t5/alfresco-archive/sql-server-and-index-key-size-limit-of-900-bytes/m-p/206166#M159296 gregdavisfromnj 2014-09-04T21:10:31Z Re: SQL Server and index key size limit of 900 bytes https://connect.hyland.com/t5/alfresco-archive/sql-server-and-index-key-size-limit-of-900-bytes/m-p/206167#M159297 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for reporting this. However the chance that this becomes an issue is quite small, because tentant ids are often not that large.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Mon, 08 Sep 2014 18:59:32 GMT https://connect.hyland.com/t5/alfresco-archive/sql-server-and-index-key-size-limit-of-900-bytes/m-p/206167#M159297 trademak 2014-09-08T18:59:32Z