title: How to resolve 900 key length limit index on the column which have datatype varchar(4096) in SQL Server 2005?
body: <p>This is the query for creating index
  create index idx_ncl_2 on BFPRODATTRASSOCIATION (value,attributeid) include (productid)</p>
  
  <p>Table structure of BFPRODATTRASSOCIATION</p>
  
  <pre><code>ProdAttrAssociationId bigint no 8
  ProductId             bigint no 8
  AttributeId           bigint  no  8
  Value                 varchar no 4096
  </code></pre>
  
  <p>I am getting this error:</p>
  
  <p>The maximum key length is 900 bytes. The index ‘idx_ncl_2’ has maximum length of 1237 bytes. </p>
  
  <p>I have to create a nonclustered index on this column. Is there any way i can create index for the column which have datatype of varchar and size is greater than 900.</p>
  
  <p>Please suggest.</p>