What will happen when composite index exceeds 900 bytes

[wg26]

Hi Everyone:

I have created composite index by using Query Analyzer. Because the total bytes of this index exceeds 900 bytes,I got warning message...but index has been created...my question is that if anyone know what will happen if I am writting data into the table and the total bytes of columns which are included in the composite index exceed 900 bytes? does SQL stop running? or SQL just skip that row, which total bytes exceed 900 bytes? Can anyone give me some ideas? Thanks alot

 

[JayKusch]

This link may help

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_0ldf.asp

Thanks

J. Kusch