SQL Server Error Code – 3805 warning: index ?%.*ls? on table ?%.*ls?.

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

SQL Server Error Code

3805

SQL Server Error Description for the Code :3805

Warning: Index ?%.*ls? on table ?%.*ls?.?%.*ls? might be corrupted because it references computed column ?%.*ls? containing a non-deterministic conversion from string to date. Run DBCC CHECKTABLE to verify index. Consider using explicit CONVERT with deterministic date style such as 121. Computed column indexes referencing non-deterministic expressions can?t be created in 90 compatibility mode. See Books Online topic ?Creating Indexes on Computed Columns? for more information.

Leave Your Comment