Category: SQL Server

SQL Server Error Code – 22962 two capture instances already exist for

In this blog post, you’ll learn more about the SQL Server Error Code 22962 and the error message description that is shown SQL Server Error Code 22962 SQL Server Error Description for the Code :22962 Two capture instances already exist for source table ‘%s.%s’. A table can have at most two capture instances. If the current tracking options are not appropriate, disable change tracking for…

SQL Server Error Code – 29317 communication involving configuration ma

In this blog post, you’ll learn more about the SQL Server Error Code 29317 and the error message description that is shown SQL Server Error Code 29317 SQL Server Error Description for the Code :29317 Communication involving configuration manager and agent is ignoring stale message from brick to brick due to ‘%s’ mismatch. Expected %I64u but received %I64u.

SQL Server Error Code – 17102 failed to initialize distributed com (co

In this blog post, you’ll learn more about the SQL Server Error Code 17102 and the error message description that is shown SQL Server Error Code 17102 SQL Server Error Description for the Code :17102 Failed to initialize Distributed COM (CoInitializeEx returned %lx). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

SQL Server Error Code – 19474 failed to set the resource dependency ex

In this blog post, you’ll learn more about the SQL Server Error Code 19474 and the error message description that is shown SQL Server Error Code 19474 SQL Server Error Description for the Code :19474 Failed to set the resource dependency expression ‘%ls’ for the WSFC resource ‘%.*ls’. The error code is %d. The WSFC service may not be running or may be inaccessible in…

SQL Server Error Code – 22855 warning: the @allow_partition_switch par

In this blog post, you’ll learn more about the SQL Server Error Code 22855 and the error message description that is shown SQL Server Error Code 22855 SQL Server Error Description for the Code :22855 Warning: The @allow_partition_switch parameter is set to 1. Change data capture will not track changes introduced in the table resulting from a partition switch which will cause data inconsistency when…

SQL Server Error Code – 2201 %sderivation from ?anysimpletype? by res

In this blog post, you’ll learn more about the SQL Server Error Code 2201 and the error message description that is shown SQL Server Error Code 2201 SQL Server Error Description for the Code :2201 %sDerivation from ?anySimpleType? by restriction is not permitted, and derivation by restriction from a type derived from ?anySimpleType? by extension is allowed only if no constraining facets are specified.