Category: SQL Server

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.