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 !!