title: Workaround maximum key length for a nonclustered index in SQL Server
body: <p>Is there a way to increase the limit for a nonclustered index which is 1700 bytes in SQL Server? When I build my database I get this warning:</p>
  
  <blockquote>
    <p>Warning! The maximum key length for a nonclustered index is 1700 bytes. The index 'CS_UK' has maximum length of 8000 bytes. For some combination of large values, the insert/update operation will fail.</p>
  </blockquote>
  
  <p>Or do I have to change the structure of my indexes?</p>