Tuesday, 16 March 2021

Is of a type that is invalid for use as a key column in an index -

 Error – While creating clustered index - is of a type that is invalid for use as a key column in an index. 
Hi All,

This error occurs if the column to which you are creating index is of type nvarchar(max). To resolve this change the datatype from nvarchar (max) to nvarchar(300) or any length of your data 

Was so surprised that it worked !!