SQL Server Error Msg 9929 – Computed column ‘%.*ls’ cannot be used as full-text type column for image or varbinary(MAX) column. This computed column must be deterministic, precise or persisted, with a size less or equal than %d characters.

In this blog post, let’s learn about the error message “9929 – Computed column ‘%.*ls’ cannot be used as full-text type column for image or varbinary(MAX) column. This computed column must be deterministic, precise or persisted, with a size less or equal than %d characters.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

9929 – Computed column ‘%.*ls’ cannot be used as full-text type column for image or varbinary(MAX) column. This computed column must be deterministic, precise or persisted, with a size less or equal than %d characters.

Reason for the Error

To be update soon…

Solution

To be update soon…