SQL Server Error Msg 3806 – Warning: Indexed view “%.*ls”.”%.*ls” might be corrupted because it contains a non-deterministic conversion from string to date. Run DBCC CHECKTABLE to verify view. Consider using explicit CONVERT with deterministic date style such as 121. Indexed views referencing non-deterministic expressions can’t be created in 90 compatibility mode. See Books Online topic “Creating Indexed Views” for more information.

In this blog post, let’s learn about the error message “3806 – Warning: Indexed view “%.*ls”.”%.*ls” might be corrupted because it contains a non-deterministic conversion from string to date. Run DBCC CHECKTABLE to verify view. Consider using explicit CONVERT with deterministic date style such as 121. Indexed views referencing non-deterministic expressions can’t be created in 90 compatibility mode. See Books Online topic “Creating Indexed Views” for more information.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

3806 – Warning: Indexed view “%.*ls”.”%.*ls” might be corrupted because it contains a non-deterministic conversion from string to date. Run DBCC CHECKTABLE to verify view. Consider using explicit CONVERT with deterministic date style such as 121. Indexed views referencing non-deterministic expressions can’t be created in 90 compatibility mode. See Books Online topic “Creating Indexed Views” for more information.

Reason for the Error

To be update soon…

Solution

To be update soon…