The error isn't caused by creating the index. The error is caused by `TRY_CAST` when the computed column values are evaluated at index creation.

If I run this:

    SELECT TRY_CAST(REPLICATE(CONVERT(nvarchar(MAX), N'a'), 4001) AS bigint)

I get the same error.

The [documentation][1] says (emphasis mine):

> If the cast succeeds, TRY_CAST returns the value as the specified data_type; if an error occurs, null is returned. However **if you request a conversion that is explicitly not permitted, then TRY_CAST fails with an error.**

Now, it's not exactly clear under which cases it will fail with an error (seems kind of asinine given the whole *point* of the function, but anyway...), so we can fix up the code by transforming the input values (use something reasonable for the data in your table), as there's no need to process a huge string when it won't fit in a bigint anyway:

    SELECT TRY_CAST(LEFT(REPLICATE(CONVERT(nvarchar(MAX), N'1'), 4001), 100) AS bigint)

This returns `NULL` as the value isn't valid, but it doesn't bomb with an error.


  [1]: http://technet.microsoft.com/en-us/library/hh974669%28v=sql.110%29.aspx