In this blog post, let’s learn about the error message “4992 – Cannot use table option LARGE VALUE TYPES OUT OF ROW on a user table that does not have any of large value types varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns in it. This option can be applied to tables having large values computed column that are persisted.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
4992 – Cannot use table option LARGE VALUE TYPES OUT OF ROW on a user table that does not have any of large value types varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns in it. This option can be applied to tables having large values computed column that are persisted.
Reason for the Error
To be update soon…
Solution
To be update soon…