Category: SQL Server

SQL Server Error Code – 20712 unable to acquire the replication merge

In this blog post, you’ll learn more about the SQL Server Error Code 20712 and the error message description that is shown SQL Server Error Code 20712 SQL Server Error Description for the Code :20712 Unable to acquire the replication merge administrative application lock for database ‘%s’. This could be due an active snapshot running while the schema change (DDL) or the administrative proc change…

SQL Server Error Code – 22911 the capture job cannot be used by change

In this blog post, you’ll learn more about the SQL Server Error Code 22911 and the error message description that is shown SQL Server Error Code 22911 SQL Server Error Description for the Code :22911 The capture job cannot be used by Change Data Capture to extract changes from the log when transactional replication is also enabled on the same database. When Change Data Capture…

SQL Server Error Code – 5856 the %s_msg range that specifies %s_msg %

In this blog post, you’ll learn more about the SQL Server Error Code 5856 and the error message description that is shown SQL Server Error Code 5856 SQL Server Error Description for the Code :5856 The %S_MSG range that specifies %S_MSG %d includes at least one %S_MSG that is not available to the current instance.  The maximum %S_MSG number that is available to this instance…

SQL Server Error Code – 39107 columns in parameters ‘@input_data_1_par

In this blog post, you’ll learn more about the SQL Server Error Code 39107 and the error message description that is shown SQL Server Error Code 39107 SQL Server Error Description for the Code :39107 Columns in parameters ‘@input_data_1_partition_by_columns’ and ‘@input_data_1_order_by_columns’ must be unique. Column name ‘%.*ls’ appears in both parameters.