Tag: MS SQL Server Error Codes

SQL Server Error Code – 8720 cannot execute query. there is more than

In this blog post, you’ll learn more about the SQL Server Error Code 8720 and the error message description that is shown SQL Server Error Code 8720 SQL Server Error Description for the Code :8720 Cannot execute query. There is more than one TABLE HINT clause specified for object ‘%.*ls’. Use at most one such TABLE HINT clause per table reference.

SQL Server Error Code – 22578 cannot change publication “%s” to disall

In this blog post, you’ll learn more about the SQL Server Error Code 22578 and the error message description that is shown SQL Server Error Code 22578 SQL Server Error Description for the Code :22578 Cannot change publication “%s” to disallow use_partition_groups because it contains one or more logical record relationships. When using logical record relationships the publication must set the @use_partition_groups property to ‘true’.

SQL Server Error Code – 21676 heterogeneous subscriber ‘%s’ could not

In this blog post, you’ll learn more about the SQL Server Error Code 21676 and the error message description that is shown SQL Server Error Code 21676 SQL Server Error Description for the Code :21676 Heterogeneous subscriber ‘%s’ could not add a subscription for heterogeneous publication ‘%s’ because publication sync method is not ‘character’, ‘concurrent_c’, or ‘database snapshot character’.

SQL Server Error Code – 12405 the command failed because the query sto

In this blog post, you’ll learn more about the SQL Server Error Code 12405 and the error message description that is shown SQL Server Error Code 12405 SQL Server Error Description for the Code :12405 The command failed because the query store is not enabled for database (%ld). Make sure that the query store is enabled for the database and rerun the command.

SQL Server Error Code – 12358 enabling cdc creates database triggers o

In this blog post, you’ll learn more about the SQL Server Error Code 12358 and the error message description that is shown SQL Server Error Code 12358 SQL Server Error Description for the Code :12358 Enabling CDC creates database triggers on ALTER TABLE and DROP TABLE. Hence, these DDL statements are not supported with %S_MSG on CDC enabled databases. Other DDL triggers not related to…