Errors 22000 - 22999

22101

16

No

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.

22103

16

No

The arguments supplied are not valid for the VERSION option of the CHANGETABLE function.

22105

16

No

Change tracking is not enabled on table '%.*ls'.

22107

16

No

Object '%.*ls' is of a data type that is not supported by the CHANGETABLE function. The object must be a user-defined table.

22109

16

No

The "context" argument for the CHANGE_TRACKING_CONTEXT WITH clause must be of type varbinary data type with a maximum length of 128.

22111

16

No

The column '%.*ls' specified in the CHANGETABLE(VERSION ...) function is not part of the primary key for table '%.*ls'.

22113

16

No

%S_MSG is not allowed because the table is being tracked for change tracking.

22115

16

No

Change tracking is enabled for one or more tables in database '%.*ls'. Disable change tracking on each table before disabling it for the database. Use the sys.change_tracking_tables catalog view to obtain a list of tables for which change tracking is enabled.

22500

16

No

Unexpected

22502

16

No

Not All articles in the publication passed data validation (rowcount only)

22504

16

No

Applying the snapshot to the Subscriber.

22506

16

No

No data needed to be merged.

22508

16

No

Downloading data changes to the Subscriber.

22510

16

No

Retrieving publication information.

22512

16

No

Cannot use partition groups with unfiltered publications. Set "use_partition_groups" to "false" using sp_changemergepublication.

22514

16

No

Cannot use partition groups because one or more filters reference the following view, which contains functions: "%s".

22516

16

No

The publication "%s" was defined as having dynamic filters, but it does not contain any dynamic filters.

22518

16

No

Cannot use column of type image, ntext, xml, CLR type, varchar(max), nvarchar(max), or varbinary(max) in a subset or join filter for article: '%s'.

22520

10

No

A filtering type changed for the article. Any pending or future changes made in this article by a Subscriber in a given partition will no longer be propagated to Subscribers in other partitions. Check the documentation for details.

22522

16

No

Article '%s' cannot be published because it is published in another merge publication. An article that has a value of 3 for the @partition_options parameter of sp_addmergearticle (nonoverlapping partitions with a single subscription per partition) cannot be included in multiple publications or subscriptions, and cannot be republished. To include the article in multiple publications, use sp_changemergearticle to specify a different value for the partition_options property of the existing article.

22524

16

No

Article '%s' is published in another merge publication, with a different value specified for the @partition_options parameter of sp_addmergearticle. The specified value must be the same in all merge publications. Either specify the same value as the existing article or change the existing article using sp_changemergearticle.

22526

16

No

An invalid value was specified for %s. Valid values are 0 (none), 1 (enforced partitions), 2 (nonoverlapping partitions with multiple subscriptions per partition), and 3 (nonoverlapping partitions with single subscription per partition).

22528

16

No

Cannot use a retention period unit other than "days" for publication "%s" because the compatibility level of the publication is lower than 90. Use sp_changemergepublication to set publication_compatibility_level to 90RTM.

22530

16

No

Cannot update any column in article "%s" that is used in a logical record relationship clause.

22532

10

No

Upload of Subscriber changes to the Publisher.

22534

16

No

Character mode publication does not support partitioned tables.

22536

16

No

The %s parameter value cannot be updated or changed for heterogeneous publications.

22538

16

No

Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.

22540

16

No

Cannot change publication "%s" to use sync_mode of "character", because it contains one or more logical record relationships.

22542

16

No

Invalid value for property @subscriber_upload_options. Valid values are 0 (allow uploads), 1 (disable uploads), 2 (disable uploads prohibit subscriber changes), and 3 (disable_outofpartition_subscriber_changes).

22544

10

No

Warning: The procedure sp_mergecleanupmetadata has been deprecated. In SQL Server 2000 SP1 and later, the merge agent calls sp_mergemetadataretentioncleanup every time it runs, so manual cleanup of metadata is not needed. Ignoring passed-in parameters and calling sp_mergemetadataretentioncleanup.

22546

16

No

Cannot change publication "%s" to allow Web synchronization because it contains one or more logical record relationships.

22548

16

No

Vertical partitioning is only allowed for log-based articles.

22550

16

No

Cannot drop identity column "%s" from the vertical partition when identityrangemanagementoption is set to auto.

22552

16

No

A valid value for parameter "@resync_date_str" needs to be provided when "@resync_type" is set to 2.

22554

16

No

Cannot change publication "%s" to use the sync_mode of "character" because it uses a retention period unit other than "day". Use sp_changemergepublication to set the retention period unit to "day".

22556

16

No

Invalid value for the property "%s". Valid values are 1 and 0.

22558

16

No

The status of the schema change could not be updated.

22560

16

No

Merge replication does not allow filters that reference dynamic functions that take one or more parameters. Check the function "%s".

22562

16

No

Cannot change the compatibility level of a publication to a value lower than the existing value.

22564

16

No

uses ddl replication

22566

16

No

uses logical records

22568

16

No

contains one or more articles which will not compensate for errors

22570

16

No

contains one or more articles that use automatic identity range management

22572

16

No

contains one or more articles with a timestamp column

22574

16

No

contains one or more articles that use vertical partitioning

22576

10

No

Invalid failover_mode value of %d was specified for [%s].[%s].[%s], setting to 0 [immediate].

22578

16

No

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'.

22580

16

No

Cannot publish database '%s' because it is marked as published on a different server. Before attempting to publish this database, execute sp_replicationdboption, specifying a value of FALSE for 'publish' and 'merge publish'.

22582

16

No

Article '%s' cannot be added or modified in publication '%s'. The replication of FILESTREAM columns is not supported for publications that have a 'publication_compatibility_level' of less than "90RTM" (SQL Server 2005). Specify a 'publication_compatibility_level' greater than or equal to "90RTM" by using sp_addmergepublication or sp_changemergepublication, or partition the article vertically so that the FILESTREAM column is not replicated.

22584

10

No

Warning: Values of some of the flags specified in the 'schema_option' property are not compatible with the publication's compatibility level. The modified schema_option value of '%s' will be used instead.

22586

16

No

Column '%s' cannot be added or modified in article '%s' of publication '%s'. The DDL operatoin on hierarchyid and FILESTREAM columns is not supported for publications that have a 'sync_mode' of 1 (character mode) or with a lower than 90RTM backward compatibility level.

22802

16

No

Starting the Change Data Capture Cleanup Agent job using low watermark %s.

22804

16

No

Change Data Capture cannot proceed with the job-related action because transactional replication is enabled on database %s but Distributor information cannot be retrieved to determine the state of the logreader agent. Make the Distributor database available, or disable distribution.

22806

16

No

The originator ID '%s' is not valid. You must specify a non-zero ID that has never been used in the topology.

22808

16

No

Cannot execute procedure '%s'. Publication '%s' must be enabled for peer-to-peer replication before you execute this procedure. To enable the publication for peer-to-peer replication, use sp_changepublication.

22810

16

No

The @action parameter value is not valid. Valid values are 'enable' and 'disable'.

22812

10

No

The roundtrip '%s' finished with timeout: %d seconds.

22814

10

No

The topology contains a duplicate originator ID. To use conflict detection, the originator ID must be unique across the topology.

22816

16

No

The qualified table name '%s' is too long to be enabled for peer-to-peer conflict detection.

22818

10

No

A delete-delete conflict was detected and resolved. The row could not be deleted from the peer since the row does not exist. The incoming delete was skipped.

22820

10

No

A delete-update conflict between peer %d (incoming) and peer %d (on disk) was detected and resolved. The incoming delete was applied to peer %d.

22822

10

No

An update-update conflict between peer %d (incoming) and peer %d (on disk) was detected and resolved. The incoming update was applied to peer %d.

22824

10

No

An insert-insert conflict between peer %d (incoming) and peer %d (on disk) was detected and resolved. The incoming insert was skipped by peer %d.

22827

16

No

Peer-to-peer conflict detection alert

22829

16

No

The command %s failed. The values specified for the @ins_cmd, @del_cmd or @upd_cmd cannot be appended with schema name %s within the size limit %d.

22831

16

No

Could not update the metadata that indicates database %s is not enabled for Change Data Capture. The failure occurred when executing the command '%s'. The error returned was %d: '%s'. Use the action and error to determine the cause of the failure and resubmit the request.

22833

16

No

Could not update the metadata that indicates table %s is not enabled for Change Data Capture. The failure occurred when executing the command '%s'. The error returned was %d: '%s'. Use the action and error to determine the cause of the failure and resubmit the request.

22835

16

No

Could not update the metadata for database %s to indicate that a Change Data Capture job has been dropped. The failure occurred when executing the command '%s'. The error returned was %d: '%s'. Use the action and error to determine the cause of the failure and resubmit the request.

22837

16

No

Could not delete table entries or drop objects associated with capture instance '%s'. The failure occurred when executing the command '%s'. The error returned was %d: '%s'. Use the action and error to determine the cause of the failure and resubmit the request.

22840

16

No

The application lock request '%s' needed to modify Change Data Capture metadata was not granted. The value returned from the request was %d: -1 = timeout; -2 = canceled; -3 = deadlock victim; -999 validation or other call error. Examine the error cause and resbmit the request.

22842

16

No

ALTER TABLE SWITCH statement failed because the partitioned destination table is enabled for Change Data Capture and does not have @allow_partition_switch set to 1.

22844

16

No

The '%s' option must be either 1 or 0.

22851

16

No

Could not update cdc.change_tables to indicate a change in the low water mark for database %s.

22853

10

No

Could not delete obsolete entries in the cdc.lsn_time_mapping table for database %s. The failure occurred when executing the command '%s'. The error returned was %d: '%s'. Use the action and error to determine the cause of the failure and resubmit the request.

22855

10

No

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 changes are consumed. Refer to books online for more information about partition switching behavior when using Change Data Capture.

22857

10

No

Warning: The @allow_partition_switch parameter must be 1 for tables that are not partitioned. The explicit setting of the parameter to 0 was ignored. Refer to books online for more information about partition switching behavior when using Change Data Capture.

22859

16

No

Log Scan process failed in processing log records. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22861

10

No

Unable to upgrade database '%s'. Error '%d' was raised: '%s'. Use the reported error to determine the cause of the failure and then execute sys.sp_cdc_vupgrade in the database context to rerun upgrade.

22863

16

No

Failed to insert rows into Change Data Capture change tables. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22901

16

No

The database '%s' is not enabled for Change Data Capture. Ensure that the correct database context is set and retry the operation. To report on the databases enabled for Change Data Capture, query the is_cdc_enabled column in the sys.databases catalog view.

22903

16

No

Another connection is already running 'sp_replcmds' for Change Data Capture in the current database.

22905

10

No

Database '%s' is already enabled for Change Data Capture. Ensure that the correct database context is set, and retry the operation. To report on the databases enabled for Change Data Capture, query the is_cdc_enabled column in the sys.databases catalog view.

22907

16

No

Parameter @role_name cannot be empty. Specify a value for @role_name and retry the operation. Supply null as the value if no role is to be used to gate access to captured change data.

22909

16

No

Failed to cleanup the cdc.lsn_time_mapping table in database '%s' when the last database table enabled for Change Data Capture was disabled. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22911

16

No

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 and transactional replication are both enabled on a database, use the logreader agent to extract the log changes.

22914

16

No

Only members of the sysadmin or db_owner or db_ddladmin roles can perform this operation when Change Data Capture is enabled for a database.

22918

16

No

One or more columns in the list of included columns was not a captured column of the change table %s.

22920

16

No

The named capture instance %s does not exist for database %s.

22923

16

No

Could not compute the new low endpoint for database '%s' from retention %d. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22925

16

No

The number of columns captured by capture instance '%s' exceeds the maximum allowed number: %d. Use the @captured_columns_list parameter to specify a subset of the columns less than or equal to the maximum allowed and resubmit the request.

22927

16

No

Capture instance name '%s' exceeds the length limit of 100 characters. Specify a name that satisfies the length constraint.

22929

16

No

Index '%s' must be either a primary key or a unique index for table '%s.%s'. Specify an index that meets at least one of these requirements.

22931

16

No

Source table '%s.%s' does not exist in the current database. Ensure that the correct database context is set. Specify a valid schema and table name for the database.

22938

16

No

Role name '%s' is invalid. Specify a valid name. See the topic 'Identifiers' in SQL Server Books Online for object name rules.

22940

16

No

Could not remove DDL history entries in the Change Data Capture metadata for capture instance '%s' and source table '%s.%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22942

16

No

Columns specified in the captured column list could not be mapped to columns in source table '%s.%s'. Verify that the columns specified in the parameter @captured_column_list are delimited properly and match columns in the source table.

22944

16

No

Could not create the specified database role '%s' for gating access to change table '%s.%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22946

16

No

Could not add column information to the cdc.captured_columns system table for source table '%s.%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22948

16

No

Could not create the change enumeration functions for capture instance '%s' and source table '%s.%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22950

16

No

Could not remove index column entries in the Change Data Capture metadata for capture instance '%s' and source table '%s.%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22952

16

No

Could not drop Change Data Capture objects created for capture instance '%s' and source table '%s.%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22954

16

No

Could not cleanup change tables for capture instance '%s' using low end point %s. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22956

16

No

Could not obtain the minimum LSN of the change table associated with capture instance '%s' from function 'sys.fn_cdc_get_min_lsn'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22958

16

No

Could not create the function to query for all changes for capture instance '%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22960

16

No

Change data capture instance '%s' has not been enabled for the source table '%s.%s'. Use sys.sp_cdc_help_change_data_capture to verify the capture instance name and retry the operation.

22962

16

No

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 the obsolete instance by using sys.sp_cdc_disable_table and retry the operation.

22964

16

No

LSN %s, specified as the new low end point for change table cleanup must represent the start_lsn value of a current entry in the cdc.lsn_time_mapping table. Choose an LSN value that satisfies this requirement.

22966

16

No

Could not create table dbo.systranschemas in database '%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22968

16

No

Could not create DDL trigger '%s' when enabling Change Data Capture for database '%s'. Additional messages in the SQL Server error log and system event log may provide more detail.

22971

16

No

Could not allocate memory for the log reader history cache. Verify that SQL Server has sufficient memory for all operations. Check the physical and virtual settings on the server and examine memory usage to see if another application is excessively consuming memory.

22973

16

No

The specified filegroup '%s' is not a valid filegroup for database '%s'. Specify a valid existing filegroup or create the named filegroup, and retry the operation.

22975

16

No

Source table '%s' contains one of the following reserved column names: __$start_lsn, __$end_lsn, __$seqval, __$operation, and __$update_mask. To enable Change Data Capture for this table, specify a captured column list and ensure that these columns are excluded from the list.

22977

16

No

Unable to update DDL history information to reflect columns changes applied to the tracked table associated with change table '%s'. Refer to previous errors in the current session to identify the cause and correct any associated problems.

22979

16

No

The unique index '%s' on table '%s' is used by Change Data Capture. The constraint using this index cannot be dropped or disabled.

22981

16

No

Object does not exist or access is denied.

22983

16

No

The unique index '%s' on source table '%s' is used by Change Data Capture. To alter or drop the index, you must first disable Change Data Capture on the table.

22985

16

No

Change data capture has not been enabled for source table '%s.%s'. Specify the name of a table enabled for Change Data Capture. To report on the tables enabled for Change Data Capture, query the is_tracked_by_cdc column in the sys.tables catalog view.

22987

16

No

Change Data Capture population failed writing blob data for one or more large object columns. Verify that SQL Server has sufficient memory for all operations. Check the physical and virtual memory settings on the server and examine memory usage to see if another application is consuming excessive memory.

22989

16

No

Could not enable Change Data Capture for database '%s'. Change data capture is not supported on system databases, or on a distribution database.

22991

16

No

The value specified for the parameter @maxtrans must be greater than 0.

22993

16

No

The Change Data Capture job table containing job information for database '%s' cannot be found in the msdb system database. Run the stored procedure 'sys.sp_cdc_add_job' to create the appropriate CDC capture or cleanup job. The stored procedure will create the required job table.

22995

16

No

A value for the parameter @retention cannot be specified when the job type is 'capture'. Specify NULL for the parameter, or omit the parameter from the statement.

22997

16

No

The Change Data Capture '%s' job does not exist in the system table 'msdb.dbo.cdc_jobs'. Use the stored procedure 'sys.sp_cdc_add_job' to add the Change Data Capture job.

22999

16

No

The value specified for the parameter @pollinginterval must be null or 0 when the stored procedure 'sys.sp_cdc_scan' is not being run in continuous mode.