Tag: MS SQL Server Error Codes

SQL Server Error Code – 10100 cannot create %s_msg on view “%.*ls” bec

In this blog post, you’ll learn more about the SQL Server Error Code 10100 and the error message description that is shown SQL Server Error Code 10100 SQL Server Error Description for the Code :10100 Cannot create %S_MSG on view “%.*ls” because it contains the DISTINCT keyword. Consider removing DISTINCT from the view or not indexing the view. Alternatively, consider replacing DISTINCT with GROUP BY…

SQL Server Error Code – 22101 the value supplied for the change_column

In this blog post, you’ll learn more about the SQL Server Error Code 22101 and the error message description that is shown SQL Server Error Code 22101 SQL Server Error Description for the Code :22101 The value supplied for the change_columns argument of CHANGE_TRACKING_IS_COLUMN_IN_MASK function is not valid. The value must be a bitmask returned by the CHANGETABLE(CHANGES …) function.

SQL Server Error Code – 19035 ole task allocator failed to initialize.

In this blog post, you’ll learn more about the SQL Server Error Code 19035 and the error message description that is shown SQL Server Error Code 19035 SQL Server Error Description for the Code :19035 OLE task allocator failed to initialize. Heterogeneous queries, distributed queries, and remote procedure calls are unavailable. Confirm that DCOM is properly installed and configured.

SQL Server Error Code – 30077 the full-text query did not use the valu

In this blog post, you’ll learn more about the SQL Server Error Code 30077 and the error message description that is shown SQL Server Error Code 30077 SQL Server Error Description for the Code :30077 The full-text query did not use the value specified for the OPTIMIZE FOR query hint. Only single terms are allowed as values for full-text queries that contain an OPTIMIZE FOR…

SQL Server Error Code – 35453 it is a system database. make sure to ta

In this blog post, you’ll learn more about the SQL Server Error Code 35453 and the error message description that is shown SQL Server Error Code 35453 SQL Server Error Description for the Code :35453 it is a system database. Make sure to target a user database. If you want temporary clustered columnstore tables, consider creating a regular user database for them