SQL Server Error Code – 3806 warning: indexed view ?%.*ls?.?%.*ls? mi

In this blog post, you’ll learn more about the SQL Server Error Code 3806 and the error message description that is shown

SQL Server Error Code

3806

SQL Server Error Description for the Code :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.