Category: SQL Server

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

In this blog post, you’ll learn more about the SQL Server Error Code 10127 and the error message description that is shown SQL Server Error Code 10127 SQL Server Error Description for the Code :10127 Cannot create %S_MSG on view “%.*ls” because it contains one or more subqueries. Consider changing the view to use only joins instead of subqueries. Alternatively, consider not indexing this view.

SQL Server Error Code – 21759 cannot add the column ‘%s’ to the table

In this blog post, you’ll learn more about the SQL Server Error Code 21759 and the error message description that is shown SQL Server Error Code 21759 SQL Server Error Description for the Code :21759 Cannot add the column ‘%s’ to the table ‘%s’. The table already contains the maximum number of columns allowed for an article in a merge publication (246 columns).

SQL Server Error Code – 35208 availability-group ddl operations are pe

In this blog post, you’ll learn more about the SQL Server Error Code 35208 and the error message description that is shown SQL Server Error Code 35208 SQL Server Error Description for the Code :35208 Availability-group DDL operations are permitted only when you are using the master database.  Run the USE MASTER command, and retry your availability-group DDL command.