Web.QHMIT.com

SQL Server System Errors: 21000 - 21999

List of error messages between 21000 and 21999 in SQL Server 2017.

These error messages are all available by querying the sys.messages catalog view on the master database.

message_id severity is_event_logged text
21000160Cannot subscribe to an inactive publication.
21001160Cannot add a Distribution Agent at the Subscriber for a push subscription.
21002160The Distribution Agent for this subscription already exists (%s).
21003160Changing publication names is no longer supported.
21004160Cannot publish the database object '%s' because it is encrypted.
21005100For backward compatibility, sp_addpublisher can be used to add a Publisher for this Distributor. However, sp_adddistpublisher is more flexible.
21006160Cannot use sp_addpublisher to add a Publisher. Use sp_adddistpublisher.
21007160Cannot add the remote Distributor. Make sure that the local server is configured as a Publisher at the Distributor.
21008160Cannot uninstall the Distributor because there are Subscribers defined.
21009160The specified filter procedure is already associated with a table.
21010160Removed %ld replicated transactions consisting of %ld statements in %ld milliseconds (%ld rows/millisec).
21011160Deactivated subscriptions.
21012160Cannot change the 'allow_push' property of the publication to "false". There are push subscriptions on the publication.
21013160Cannot change the 'allow_pull' property of the publication to "false". There are pull subscriptions on the publication.
21014160The @optname parameter value must be 'transactional' or 'merge'.
21015160The replication option '%s' has been set to TRUE already.
21016160The replication option '%s' has been set to FALSE already.
21017160Cannot perform SQL Server 7.0 compatible checksum operation on a merge article that has a vertical or horizontal partition. Rowcount validation and SQL Server 2000 compatible binary checksum operation can be performed on this article.
21018160There are too many consecutive snapshot transactions in the distribution database. Run the Log Reader Agent again or clean up the distribution database.
21019100Distribution agent for subscription added.
21020100no comment specified.
21021160Drop the Distributor before you uninstall replication.
21022160If set 'immediate_sync' property of a publication to true then must also set 'independent_agent' property to true.
21023160'%s' is no longer supported.
21024160The stored procedure '%s' is already published as an incompatible type.
21025160The string being encrypted cannot have null characters.
21026160Cannot have an anonymous subscription on a publication that does not have an independent agent.
21027160'%s' replication stored procedures are not installed. You must reinstall SQL Server with Replication.
21028160Replication components are not installed on this server. Run SQL Server Setup again and select the option to install replication.
21029160Cannot drop a push subscription entry at the Subscriber unless @drop_push is 'true'.
21030160Names of SQL Server replication agents cannot be changed.
21031160'post_script' is not supported for stored procedure articles.
21032160Could not subscribe because non-SQL Server Subscriber '%s' does not support 'sync tran' update mode.
21033160Cannot drop server '%s' as Distribution Publisher because there are databases enabled for replication on that server.
21034160Rows inserted or updated at the Subscriber cannot be outside the article partition.
21035160You have updated the Publisher property '%s' successfully.
21036160Another %s agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent.
21037160Invalid working directory '%s'.
21038160Integrated Authentication is not supported by the server.
21039160The article '%s' contains the destination owner '%s'. Non-SQL Server Subscribers require articles to have the destination owner of NULL.
21040160Publication '%s' does not exist.
21041160A remote distribution Publisher is not allowed on this server version.
21042160The distribution Publisher property, 'distributor_password', has no usage and is not supported for a Distributor running on Windows NT 4.0.
21043160The Distributor is not installed.
21044160Cannot ignore the remote Distributor (@ignore_remote_distributor cannot be 1) when enabling the database for publishing or merge publishing.
21045160Cannot uninstall the Distributor because there are databases enabled for publishing or merge publishing.
21046160Cannot change distribution Publisher property 'distribution_db' because the Publisher is using the current distribution database.
21047160Cannot drop the local distribution Publisher because there are Subscribers defined.
21048160Cannot add login '%s' to the publication access list because it does not have access to the distribution server '%s'.
21049160The login '%s' does not have access permission on publication '%s' because it is not in the publication access list.
21050160Only members of the sysadmin fixed server role or db_owner fixed database role can perform this operation. Contact an administrator with sufficient permissions to perform this operation.
21051160Could not subscribe because non-SQL Server Subscriber '%s' does not support custom stored procedures.
21052160Cannot write to the message queue for the queued updating subscription. Ensure that Microsoft Distributed Transaction Coordinator is running, and that the subscription is active and initialized. If the subscription uses Microsoft Message Queueing, ensure the proper permissions are set on the queue.
21053160Input property parameter is not valid. See SQL Server Books Online for a list of valid parameters for sp_changemergepublication.
21054160The trigger at the Subscriber could not execute commands at the Publisher over the linked server connection (triggers are used for Subscribers with updating subscriptions). Ensure sp_link_publication has been used to configure the linked server properly, and ensure that the login used to connect to the Publisher is in the publication access list.
21055150Invalid value for parameter %s specified for %s.
21056160The subscription to publication '%s' has expired or does not exist.
21057160Anonymous Subscribers cannot have updatable subscriptions.
21058160An updatable subscription to publication '%s' on Subscriber '%s' already exists.
21059160Cannot reinitialize subscriptions of non-immediate_sync publications.
21060160Could not subscribe because non-SQL Server Subscriber '%s' does not support parameterized statements.
21061160Invalid article status %d specified when adding article '%s'.
21062160The row size of table '%s' exceeds the replication limit of 6,000 bytes.
21063160Table '%s' cannot participate in updatable subscriptions because it is published for merge replication.
21064160The subscription is uninitialized or unavailable for immediate updating as it is marked for reinitialization. If using queued failover option, run Queue Reader Agent for subscription initialization. Try again after the (re)initialization completes.
21070160This subscription does not support automatic reinitialization (subscribed with the 'no sync' option). To reinitialize this subscription, you must drop and re-create the subscription.
21071100Cannot reinitialize article '%s' in subscription '%s:%s' to publication '%s' (subscribed with the 'no sync' option).
21072160The subscription has not been synchronized within the maximum retention period or it has been dropped at the Publisher. You must reinitialize the subscription to receive data.
21073160The publication specified does not exist.
21074160The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
21075100The initial snapshot for publication '%s' is not yet available.
21076100The initial snapshot for article '%s' is not yet available.
21077100Deactivated initial snapshot for anonymous publication(s). New subscriptions must wait for the next scheduled snapshot.
21078160Table '%s' does not exist in the Subscriber database.
21079160The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.
21080160The 'msrepl_tran_version' column must be in the vertical partition of the article that is enabled for updatable subscriptions; it cannot be dropped.
21081160Server setting 'Allow triggers to be fired which fire other triggers (nested triggers)' must exist on updatable Subscribers.
21082160Database property 'IsRecursiveTriggersEnabled' has to be false for subscription databases at Subscribers that allow updatable subscriptions.
21083160Database compatibility level at immediate updating Subscribers cannot be less than 70.
21084160Publication '%s' does not allow anonymous subscriptions.
21085160The retention period must be less than the retention period for the distribution database.
21086160The retention period for the distribution database must be greater than the retention period of any existing non-merge publications.
21087160Client subscriptions and anonymous subscriptions cannot republish data. To republish data from this database, the subscription to the root Publisher must be a server subscription with a priority greater than 0. Drop the current subscription and create a server subscription.
21088100The initial snapshot for the publication is not yet available.
21089160Only members of the sysadmin fixed server role can perform this operation.
21090160Cannot upgrade merge replication metadata. Attempt the upgrade again by running the Merge Agent for the Subscriber or by running the Snapshot Agent for the Publisher.
21091160Global subscribers with priority 0 are not allowed to create merge publications.
21092100The Change Tracking manual cleanup procedure for database %s has been executed
21101100The custom command name %s specified for parameter %s will be ignored. A system generated name will be used instead. The publication allows %s and command names need not be specified.
21105160This edition of SQL Server cannot act as a Publisher or Distributor for replication.
21106160This edition of SQL Server does not support publications.
21107160'%ls' is not a table or view.
21108160This edition of SQL Server does not support transactional publications.
21109160The parameters @xact_seqno_start and @xact_seqno_end must be identical if @command_id is specified.
21110160@xact_seqno_start and @publisher_database_id must be specified if @command_id is specified.
21111160'%s' is not a valid parameter for the Snapshot Agent.
21112160'%s' is not a valid parameter for the Log Reader Agent.
21113160'%s' is not a valid parameter for the Distribution Agent.
21114160'%s' is not a valid parameter for the Merge Agent.
21115160%d is not a valid value for the '%s' parameter. The value must be a positive integer.
21116160'%s' is not a valid value for the '%s' parameter. The value must be 1, 2, or 3.
21117160'%s' is not a valid value for the '%s' parameter. The value must be 0, 1, or 2.
21118160'%s' is not a valid value for the '%s' parameter. The value must be greater than or equal to 0 and less than or equal to 10,000.
21119160%s is not a valid value for the '%s' parameter. The value must be a non-negative integer.
21120160Only members of the sysadmin fixed server role or db_owner fixed database role, or the owner of the subscription can drop subscription '%s' to publication '%s'.
21121160Only members of the sysadmin fixed server role and '%s' can drop the pull subscription to the publication '%s'.
21122160Cannot drop the distribution database '%s' because it is currently in use.
21123160The agent profile '%s' could not be found at the Distributor.
21124160Cannot find the table name or the table owner corresponding to the alternative table ID(nickname) '%d' in sysmergearticles.
21125160A table used in merge replication must have at least one non-computed column.
21126160Pull subscriptions cannot be created in the same database as the publication.
21127160Only global merge subscriptions can be added to database '%s'.
21128160Terminating immediate updating or queued updating INSERT trigger because it is not the first trigger to fire. Use sp_settriggerorder procedure to set the firing order for trigger '%s' to first.
21129160Terminating immediate updating or queued updating UPDATE trigger because it is not the first trigger to fire. Use sp_settriggerorder procedure to set the firing order for trigger '%s' to first.
21130160Terminating immediate updating or queued updating DELETE trigger because it is not the first trigger to fire. Use sp_settriggerorder procedure to set the firing order for trigger '%s' to first.
21131160There are existing subscriptions to heterogeneous publication '%s'. To add new articles, first drop the existing subscriptions to the publication.
21132160Cannot create transactional subscription to merge publication '%s'. The publication type should be either transactional(0) or snapshot(1) for this operation.
21133160Publication '%s' is not enabled to use an independent agent.
21134160The specified job ID must identify a Distribution Agent or a Merge Agent job.
21135160Detected inconsistencies in the replication agent table. The specified job ID does not correspond to an entry in '%ls'.
21136160Detected inconsistencies in the replication agent table. The specified job ID corresponds to multiple entries in '%ls'.
21137160This procedure supports only remote execution of push subscription agents.
21138160The 'offload_server' property cannot be the same as the Distributor name.
21139160Could not determine the Subscriber name for distributed agent execution.
21140160Agent execution cannot be distributed to a Subscriber that resides on the same server as the Distributor.
21141160The @change_active flag may not be specified for articles with manual filters or views.
21142160The SQL Server '%s' could not obtain Windows group membership information for login '%s'. Verify that the Windows account has access to the domain of the login.
21143160The custom stored procedure schema option is invalid for a snapshot publication article.
21144160Cannot subscribe to publication of sync_type 'dump database' because the Subscriber has subscriptions to other publications.
21145160Cannot subscribe to publication %s because the Subscriber has a subscription to a publication of sync_type 'dump database'.
21146160@use_ftp cannot be 'true' while @alt_snapshot_folder is neither NULL nor empty.
21147160The '%s' database is not published for merge replication.
21148160Both @subscriber and @subscriberdb must be specified with non-null values simultaneously, or both must be left unspecified.
21149160The '%s' database is not published for transactional or snapshot replication.
21150160Unable to determine the snapshot folder for the specified subscription because the specified Subscriber is not known to the Distributor.
21151160Pre- and post-snapshot commands are not supported for a publication that may support non-SQL Server Subscribers by using the character-mode bcp as the synchronization method.
21152160Cannot create a subscription of sync_type 'none' to a publication using the 'concurrent' or 'concurrent_c' synchronization method.
21153160Cannot create article '%s'. All articles that are part of a concurrent synchronization publication must use stored procedures to apply changes to the Subscriber.
21154160Cannot change article '%s'. All articles that are part of a concurrent synchronization publication must use stored procedures to apply changes to the Subscriber.
21155160Cannot change article '%s'. articles that are part of a concurrent synchronization publication can not have ins_cmd/del_cmd which exceeds %d characters .
21156160The @status parameter value must be 'initiated' or 'active'.
21157160The snapshot compression option can be enabled only for a publication having an alternate snapshot generation folder defined.
21158160For a publication to be enabled for the Internet, the 'ftp_address' property must not be null.
21159160If a publication is enabled for the Internet, the 'alt_snapshot_folder' property must be non-empty.
21160160The 'ftp_port' property must be a non-negative integer < 65536.
21161160Could not change the Publisher because the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggers.
21162160It is invalid to exclude the rowguid column for the table from the partition.
21163160It is not possible to add column '%s' to article '%s' because the snapshot for publication '%s' has been run.
21164160Column '%s' cannot be included in a vertical partition because it is neither nullable nor defined with a default value.
21165160Column '%s' cannot be excluded from a vertical partition because it is neither nullable nor defined with a default value.
21166160Column '%s' does not exist.
21167160The specified job ID does not represent a %s agent job for any push subscription in this database.
21168160Only members of the sysadmin fixed server role, members of the db_owner fixed database role, and owners of subscriptions served by the specified replication agent job can modify the agent offload settings.
21169160Could not identify the Publisher '%s' at the Distributor '%s'. Make sure that the server '%s' is registered at the Distributor.
21170160The specified Subscriber cannot use transformable subscriptions using Data Transformation Services. Only SQL Server 2000, SQL Server 2005, and OLE DB Subscribers can use transformable subscriptions.
21171160Could not find package '%s' in msdb at server '%s'.
21172160The publication has to be in 'character', 'concurrent_c', or 'database snapshot character' bcp mode to allow DTS.
21173160The publication has to be 'independent_agent type' to allow DTS.
21174160Because this publication allows transformable subscriptions using DTS, it requires autogenerated stored procedures and parameterized commands, which are set using default value for the @status.
21175160You cannot change the ins_cmd, upd_cmd, or del_cmd article properties because the publication allows Data Transformation Services or updatable subscriptions.
21176160Only members of the sysadmin fixed server role, db_owner fixed database role, or the creator of the subscription can change the subscription properties.
21177160Could not create column list because it is too long. Create the list manually.
21178160Data Transformation Services (DTS) properties cannot be set because the publication does not allow transformable subscriptions using DTS. To allow transformable subscriptions, you must drop the publication and then and re-create it, specifying that transformable subscriptions are allowed.
21179160Invalid @dts_package_location parameter value. Valid options are 'Distributor' or 'Subscriber'.
21180160A publication that allows DTS cannot be enabled for updatable subscriptions.
21181160@dts_package_name can be set for push subscriptions only.
21182160The @agent_type parameter must be one of 'distribution', 'merge', or NULL.
21183160Invalid property name '%s'.
21184160%s parameter is incorrect: it should be '%s', '%s' or '%s'.
21185160The subscription is not initialized or not created for failover mode operations.
21186160Subscription for Publisher '%s' does not have a valid queue_id.
21187160The current mode is the same as the requested mode.
21188100Changed update mode from [%s] to [%s].
21189160The queue for this subscription with queue_id = '%s' is not empty. Run the Queue Reader Agent to make sure the queue is empty before setting mode from [queued] to [immediate].
21190100Overriding queue check for setting mode from [%s] to [%s].
21192160MSrepl_tran_version column is a predefined column used for replication and can be only of data type uniqueidentifier
21193160@identity_range, @pub_identity_range, or @threshold cannot be NULL when @identityrangemanagementoption is set to AUTO.
21194160Cannot support identity range management because this table does not have an identity column.
21195160A valid identity range is not available. Check the data type of the identity column.
21196160Identity automation failed.
21197160Failed to allocate new identity range.
21198160Schema replication failed.
21199160This change cannot take effect until you run the snapshot again.
21200160Publication '%s' does not exist.
21201160Dropping a column that is being used by a merge filter clause is not allowed.
21202160It is not possible to drop column '%s' to article '%s' because the snapshot for publication '%s' has already been run.
21203100Duplicate rows found in %s. Unique index not created.
21204160The publication '%s' does not allow subscription copy or its subscription has not been synchronized.
21205160The subscription cannot be attached because the publication does not allow subscription copies to synchronize changes.
21206160Cannot resolve load hint for object %d because the object is not a user table.
21207160Cannot find source object ID information for article %d.
21208160This step failed because column '%s' exists in the vertical partition.
21209160This step failed because column '%s' does not exist in the vertical partition.
21210160The publication must be immediate_sync type to allow subscription copy.
21211160The database is attached from a subscription copy file without using sp_attach_subscription. Drop the database and reattach it using sp_attach_subscription.
21212160Cannot copy subscription. Only single file subscription databases are supported for this operation.
21213160Subscribers cannot subscribe to publications that allow DTS without using a DTS package.
21214160Cannot create file '%s' because it already exists.
21215160An alternate synchronization partner can be configured only at the Publisher.
21216160Publisher '%s', publisher database '%s', and publication '%s' are not valid synchronization partners.
21217100Publication of '%s' data from Publisher '%s'.
21218160The creation_script property cannot be NULL if a schema option of 0x0000000000000000 is specified for the article.
21219160The specified source object must be a stored procedure object if it is published as a 'proc schema only' type article.
21220160Unable to add the article '%s' because a snapshot has been generated for the publication '%s'.
21221160The specified source object must be a view object if it is going to be as a 'view schema only' type article.
21222160The schema options available for a procedure, function, synonym, or aggregate schema article are: 0x00000001, 0x00000020, 0x00001000, 0x00002000, 0x00400000, 0x02000000, 0x08000000, 0x10000000, 0x20000000, 0x40000000, and 0x80000000.
21223160The @pre_creation_command parameter for a schema only article must be either 'none' or 'drop'.
21224160'%s' is not a valid property for a schema only article.
21225160The 'offload_server' property cannot be NULL or empty if the pull subscription agent is to be enabled for remote activation.
21226160The database '%s' does not have a pull subscription to the specified publication.
21227160The 'offload_server' property cannot be the same as the Subscriber server name.
21228160The specified source object must be a user-defined function object if it is going to be published as a 'func schema only' type article.
21229160The schema options available for a view schema article are: 0x00000001, 0x00000010, 0x00000020, 0x00000040, 0x00000100, 0x00001000, 0x00002000, 0x00040000, 0x00100000, 0x00200000, 0x00400000, 0x00800000, 0x01000000, 0x08000000, 0x40000000, and 0x80000000.
21230160Do not call this stored procedure for schema change because the current database is not enabled for replication.
21231160Automatic identity range support is useful only for publications that allow updating subscribers.
21232160Identity range values must be positive integers that are greater than 1.
21233160Threshold value must be from 1 through 100.
21234160Cannot use the INSERT command because the table has an identity column. The insert custom stored procedure must be used to set 'identity_insert' settings at the Subscriber.
21235160Article property '%s' can be set only when the article uses automatic identity range management.
21236160The subscription(s) to Publisher '%s' does not allow subscription copy or it has not been synchronized.
21237160There is a push subscription to Publisher '%s'. Only pull and anonymous subscriptions can be copied.
21238160This database either is a publisher, or there is a push subscription to publication '%s'. Only pull and anonymous subscriptions can be copied.
21239160Cannot copy subscriptions because there is no synchronized subscription found in the database.
21240160The table '%s' is already published as another article with a different automatic identity support option.
21241160The threshold value should be from 1 through 100.
21242160Conflict table for article '%s' could not be created successfully.
21243160Publisher '%s', publication database '%s', and publication '%s' could not be added to the list of synchronization partners.
21244160Character mode publication does not support vertical filtering when the base table does not support column-level tracking.
21245160Table '%s' is not part of publication '%s'.
21246160This step failed because table '%s' is not part of any publication.
21247160Cannot create file at '%s'. Ensure the file path is valid.
21248160Cannot attach subscription file '%s'. Ensure the file path is valid and the file is updatable.
21249160OLE DB or ODBC Subscribers cannot subscribe to article '%s' in publication '%s' because the article has a timestamp column and the publication is 'allow_queued_tran' (allows queued updating subscriptions).
21250160Primary key column '%s' cannot be excluded from a vertical partition.
21251160Publisher '%s', publisher database '%s', publication '%s' could not be removed from the list of synchronization partners.
21252160It is invalid to remove the default Publisher '%s', publication database '%s', and publication '%s' from the list of synchronization partners
21253160Parameter '@add_to_active_directory' cannot be set to TRUE because Active Directory client package is not installed properly on the machine where SQL Server is running.
21254160The Active Directory operation on publication '%s' could not be completed because Active Directory client package is not installed properly on the machine where SQL Server is running.
21255160Column '%s' already exists in table '%s'.
21256160A column used in filter clause '%s' either does not exist in the table '%s' or cannot be excluded from the current partition.
21257160Invalid property '%s' for article '%s'.
21258160You must first drop all existing merge publications to add an anonymous or local subscription to database '%s'.
21259160Invalid property value '%s'. See SQL Server Books Online for a list of valid parameters for sp_changemergearticle.
21260160Schema replication failed because database '%s' on server '%s' is not the original Publisher of table '%s'.
21261160The offload server must be specified if the agent for this subscription is to be offloaded for remote execution.
21262160Failed to drop column '%s' from the partition because a computed column is accessing it.
21263160Parameter '%s' cannot be NULL or an empty string.
21264160Column '%s' cannot be dropped from table '%s' because it is a primary key column.
21265160Column '%s' cannot be dropped from table '%s' because there is a unique index accessing this column.
21266160Cannot publish table '%s' for both a merge publication and a publication with the updatable subscribers option.
21267100Invalid value for queue type was specified. Valid values = (%s).
21268100Cannot change the parameter %s while there are subscriptions to the publication.
21269160Cannot add a computed column or a timestamp column to a vertical partition for a character mode publication.
21270100Queued snapshot publication property '%s' cannot have the value '%s'.
21272160Cannot clean up the meta data for publication '%s' because other publications are using one or more articles in this publication.
21273160You must upgrade the Subscriber to SQL Server 2000 to create updatable subscriptions when the Publisher is SQL Server 2000 or higher.
21274160Invalid publication name '%s'.
21275160Cannot publish the schema-bound view '%ls'. The value specified for the @type parameter must be "indexed view schema only" (for snapshot or transactional replication) or "indexed view logbased" (for transactional replication only).
21276160The type must be 'table' or '( view | indexed view | proc | func ) schema only'.
21277160Cannot publish the source object '%ls'. The value specified for the @type parameter ("indexed view schema only" or "indexed view logbased") can be used only for indexed views. Either specify a value of "view schema only" for the @type parameter, or modify the view to be schema bound with a unique clustered index.
21278160Cannot publish the source object '%ls'. The value specified for the @type parameter ("indexed view logbased") requires that the view be schema bound with a unique clustered index. Either specify a value of "view schema only" for the @type parameter, or modify the view to be schema bound with a unique clustered index.
21279160The 'schema_option' property for a merge article cannot be changed after a snapshot is generated for the publication. To change the 'schema_option' property of this article the corresponding merge publication must be dropped and re-created.
21280160Publication '%s' cannot be subscribed to by Subscriber database '%s' because it contains one or more articles that have been subscribed to by the same Subscriber database at transaction level.
21281160Publication '%s' cannot be subscribed to by Subscriber database '%s' because it contains one or more articles that have been subscribed to by the same Subscriber database at merge level.
21282160@identity_range, @pub_identity_range, and @threshold must be NULL when @identityrangemanagementoption is set to 'none' or 'manual'.
21283160Column '%s' of table '%s' cannot be excluded from a vertical partition because there is a computed column that depends on it.
21284160Failed to drop column '%s' from table '%s'.
21285160Failed to add column '%s' to table '%s'.
21286160Conflict table '%s' does not exist.
21287160The specified @destination_folder is not a valid path of an existing folder.
21288160Could not create the snapshot directory structure in the specified @destination_folder.
21289160Either the snapshot files have not been generated or they have been cleaned up.
21290160The identity range value provided has exceeded the maximum value allowed.
21291160The specified automatic identity support parameters conflict with the settings in another article.
21292160Object '%s' cannot be published twice in the same publication.
21293100Warning: adding updatable subscription for article '%s' may cause data inconsistency as the source table is already subscribed to '%s'
21294160Either @publisher (and @publisher_db) or @subscriber (and @subscriber_db) must be specified, but both cannot be specified.
21295160Publication '%s' does not contain any article that uses automatic identity range management.
21296160Parameter @resync_type must be either 0, 1, 2.
21297160Invalid resync type. No validation has been performed for this subscription.
21298160Failed to resynchronize this subscription.
21299160Invalid Subscriber partition validation expression '%s'.
21300100The resolver information was specified without specifying the resolver to be used for article '%s'. The default resolver will be used.
21301160The resolver information should be specified while using the '%s' resolver.
21302160The resolver information should specify a column with data type, datetime, or smalldatetime while using the '%s' resolver.
21303160The article '%s' should enable column tracking to use the '%s' resolver. The default resolver will be used to resolve conflicts on this article.
21304160The merge triggers could not be created on the table '%s'.
21305160The schema change information could not be updated at the subscription database.
21306160The copy of the subscription could not be made because the subscription to publication '%s' has expired.
21307160The subscription could not be attached because the subscription to publication '%s' has expired.
21308100Rowcount validation profile.
21309100Profile used by the Merge Agent to perform rowcount validation.
21310100Rowcount and checksum validation profile.
21311100Profile used by the Merge Agent to perform rowcount and checksum validation.
21312100Cannot change this publication property because there are active subscriptions to this publication.
21313100Subscriber partition validation expression must be NULL for static publications.
21314100There must be one and only one of '%s' and '%s' that is not NULL.
21315100Failed to adjust Publisher identity range for table '%s'.
21316100Failed to adjust Publisher identity range for publication '%s'.
21317100A push subscription to the publication '%s' already exists. Use sp_mergesubscription_cleanup to drop defunct push subscriptions.
21318100Table '%s' must have at least one column that is included in the vertical partition.
21319160Could not find the Snapshot Agent command line for the specified publication. Check that a valid regular snapshot job exists on the distributor.
21320160The version of the Distributor cannot be lower than the version of the Publisher.
21321160The parameter @dynamic_snapshot_location cannot be an empty string.
21322160This publication logs conflicts on both replicas. Pre-SQL Server 2005 subscribers will not honor this setting.
21323160A dynamic snapshot job can be scheduled only for a publication with dynamic filtering enabled.
21324160A Snapshot Agent must be added for the specified publication before a dynamic snapshot job can be scheduled.
21325160Could not find the Snapshot Agent ID for the specified publication.
21326160Could not find the dynamic snapshot job with a '%ls' of '%ls' for the specified publication.
21327160'%ls' is not a valid dynamic snapshot job name.
21328160The specified dynamic snapshot job name '%ls' is already in use. Try the operation again with a different job name.
21329160Only one of the parameters, @dynamic_snapshot_jobid or @dynamic_snapshot_jobname, can be specified with a nondefault value.
21330160Cannot create a sub-directory under the snapshot folder (%ls). Ensure that there is enough disk space available, and that the account under which the Snapshot Agent runs has permissions to create a sub-directory under the snapshot folder.
21331160Cannot copy user script file to the snapshot folder at the Distributor (%ls). Ensure that there is enough disk space available, and that the account under which the Snapshot Agent runs has permissions to write to the snapshot folder and its subdirectories.
21332160Failed to retrieve information about the publication : %ls. Check the name again.
21333160A generation that was expected to be in %s.dbo.MSmerge_genhistory could not be found. If this error occurred in a subscription database, reinitialize the subscription. If this error occurred in a publication database, restore the database from a backup.
21334160Cannot initialize Message Queuing-based subscription because the platform is not Message Queuing %s compliant
21335160Warning: column '%s' already exists in the vertical partition.
21336160Warning: column '%s' does not exist in the vertical partition.
21337160Invalid @subscriber_type value. Valid options are 'local' and 'global'.
21338160Cannot execute sp_dropmergearticle if the publication has a Subscriber that is running on a version of SQL Server 2000 or earlier. Drop and re-create the publication without the article '%s' or set the publication compatibility level of publication '%s' to '90RTM' before calling sp_dropmergearticle.
21339100Warning: the publication uses a feature that is only supported only by subscribers running '%s' or higher.
21340160On Demand user script cannot be applied to the snapshot publication.
21341160@dynamic_snapshot_location cannot be a non-empty string while @alt_snapshot_folder is neither empty nor null.
21342160@dynamic_snapshot_location cannot be a non-empty string while @use_ftp is 'true'.
21343160Could not find stored procedure '%s'.
21344160Invalid value specified for %ls parameter.
21345160Excluding the last column in the partition is not allowed.
21346160Failed to change the owner of '%s' to '%s'.
21347160Column '%s' cannot be excluded from the vertical partitioning because there is a unique index accessing this column.
21348160Invalid property name '%s'.
21349100Warning: only Subscribers running SQL Server 7.0 Service Pack 2 or later can synchronize with publication '%s' because decentralized conflict logging is designated.
21350100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because a compressed snapshot is used.
21351100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because vertical filters are being used.
21352100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because schema replication is performed.
21353100Warning: only Subscribers running SQL Server 7.0 Service Pack 2 or later can synchronize with publication '%s' because publication wide reinitialization is performed.
21354100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because publication wide reinitialization is performed.
21355100Warning: only Subscribers running SQL Server 7.0 Service Pack 2 or later can synchronize with publication '%s' because merge metadata cleanup task is performed.
21356100Warning: only Subscribers running SQL Server 7.0 Service Pack 2 or later can synchronize with publication '%s' because publication wide validation task is performed.
21357100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because data types new in SQL Server 2000 exist in one of its articles.
21358100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because at least one timestamp column exists in one of its articles.
21359100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because automatic identity ranges are being used.
21360100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because a new article has been added to the publication after its snapshot has been generated.
21361160The specified @agent_jobid is not a valid job id for a '%s' agent job.
21362160Merge filter '%s' does not exist.
21363160Failed to add publication '%s' to Active Directory. %s
21364160Could not add article '%s' because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.
21365160Could not add article '%s' because there are active subscriptions. Set @force_reinit_subscription to 1 to force this and reinitialize the active subscriptions.
21366160Could not add filter '%s' because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.
21367160Could not add filter '%s' because there are active subscriptions. Set @force_reinit_subscription to 1 to force this and reinitialize the active subscriptions.
21368160The specified offload server name contains the invalid character '%s'.
21369160Could not remove publication '%s' from Active Directory.
21370160The resync date specified '%s' is not a valid date.
21371100Could not propagate the change on publication '%s' to Active Directory.
21372160Cannot drop filter '%s' from publication '%s' because its snapshot has been run and this publication could have active subscriptions. Set @force_reinit_subscription to 1 to reinitialize all subscriptions and drop the filter.
21373110Could not open database %s. Replication settings and system objects could not be upgraded. If the database is used for replication, run sp_vupgrade_replication in the [master] database when the database is available.
21374100Upgrading distribution settings and system objects in database %s.
21375100Upgrading publication settings and system objects in database %s.
21376110Could not open database %s. Replication settings and system objects could not be upgraded. If the database is used for replication, run sp_vupgrade_replication in the [master] database when the database is available.
21377100Upgrading subscription settings and system objects in database %s.
21378160Could not open distribution database %s because it is offline or being recovered. Replication settings and system objects could not be upgraded. Be sure this database is available and run sp_vupgrade_replication again.
21379160Cannot drop article '%s' from publication '%s' because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.
21380160Cannot add timestamp column without forcing reinitialization. Set @force_reinit_subscription to 1 to force reinitialization.
21381160Cannot add (drop) column to table '%s' because the table belongs to publication(s) with an active updatable subscription. Set @force_reinit_subscription to 1 to force reinitialization.
21382160Cannot drop filter '%s' because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.
21383160Cannot enable a merge publication on this server because the working directory of its Distributors is not using a UNC path.
21384160The specified subscription does not exist or has not been synchronized yet.
21385160Snapshot failed to process publication '%s'. Possibly due to active schema change activity or new articles being added.
21386160Schema change failed on object '%s'. Possibly due to active snapshot or other schema change activity.
21387160The expanded dynamic snapshot view definition of one of the articles exceeds the system limit of 3499 characters. Consider using the default mechanism instead of the dynamic snapshot for initializing the specified subscription.
21388100The concurrent snapshot for publication '%s' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for the publication must be restarted until a complete snapshot is generated.
21389100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because column-level collation is scripted out with the article schema creation script.
21390100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because extended properties are scripted out with the article schema creation script.
21391100Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because it contains schema-only articles.
21392160Row filter(%s) is invalid for column partition(%s) for article '%s' in publication '%s'.
21393160Dropping row filter(%s) for article '%s' in '%s'. Reissue sp_articlefilter and sp_articleview to create a row filter.
21394160Invalid schema option specified for publication that allows updating subscribers. Need to set the schema option to include DRI constraints.
21395100This column cannot be included in a transactional publication because the column ID is greater than 255.
21396160The value specified for the @type parameter of sp_addsubscriber or the @subscriber_type parameter of sp_addsubscription is not valid. See SQL Server Books Online for a list of valid values.
21397160The transactions required for synchronizing the nosync subscription created from the specified backup are unavailable at the Distributor. Retry the operation again with a more up-to-date log, differential, or full database backup.
21398160Could not complete setting up the no-sync subscription at the Distributor while the distribution cleanup agent is running. The operation has a greater chance of success if the distribution cleanup agent is temporarily disabled.
21399160The transactions required for synchronizing the subscription with the specified log sequence number (LSN) are unavailable at the Distributor. Specify a higher LSN.
21400160Article property must be changed at the original Publisher of article '%s'.
21401160Article name cannot be 'all'.
21402160Incorrect value for parameter '%s'.
21403100The 'max_concurrent_dynamic_snapshots' publication property must be greater than or equal to zero.
21404100'%s' is not a valid value for the '%s' parameter. The value must be a positive integer greater than 300 or 0.
21405100'%s' is not a valid value for the '%s' parameter. The value must be an integer greater than or equal to %d.
21406100'%s' is not a valid value for the '%s' parameter. The value must be 0 or 1.
21407160Cannot create the subscription. If you specify a value of "initialize with backup" for the @sync_type parameter, you must subscribe to all articles in the publication by specifying a value of "all" for the @article parameter.
21408160Cannot create the subscription. You must specify a value of "Active" or "Subscribed" for the @status parameter. This is because the value specified for the @sync_type parameter is "initialize with backup" or "replication support only".
21409160Only one of parameters %s and %s can be set.
21410160Snapshot Agent startup message.
21411160Distribution Agent startup message.
21412160Merge Agent startup message.
21413160Failed to acquire the application lock indicating the front of the queue.
21414100Unexpected failure acquiring an application lock. Ensure that the account under which the Merge Agent runs is a member of the publication access list. If there is a lot of activity on the server, run the Merge Agent when there are more server resources available.
21415100Unexpected failure releasing an application lock. Ensure that the account under which the Merge Agent runs is a member of the publication access list. If there is a lot of activity on the server, run the Merge Agent when there are more server resources available.
21416100Property '%s' of article '%s' cannot be changed.
21417100Having a queue timeout value of over 12 hours is not allowed.
21419100Filter '%s' of article '%s' cannot be changed.
21420100Subscription property '%s' cannot be changed.
21421100Article '%s' cannot be dropped because there are other articles using it as a join article.
21422160Queue Reader Agent startup message.
21423160Either the publication '%s' does not exist or you do not have sufficient permissions to access it. Ensure that the publication exists and that the account under which the Merge Agent connects to the Publisher is included in the publication access list (PAL).
21424160The @publisher parameter must be NULL for SQL Server publishers.
21425160The @publisher parameter may not be NULL for heterogeneous publishers.
21426160No shared agent subscription exists for publication '%s' and the subscriber/subscriber database pair '%s'/'%s'.
21428160'memory_optimized' property can be enabled only for SQL Server Subscriber.
21429160Changing from sql subscriber to a non-sql subscriber is not allowed when the memory-optimized property is enabled.
21430160The use of P2P Replication is not supported for subscription with memory-optimized tables.
21450160The replication %s could not be upgraded for %s databases. Ensure that %s is upgraded and execute %s again.
21451160The %s %s (%s) login (%s) password has been changed.
21452100Warning: The %s agent job has been implicitly created and will run under the SQL Server Agent Service Account.
21454160The internal procedure sp_MStran_is_snapshot_required must be executed at the Distributor if the @run_at_distributor parameter has a value of 1. If the problem persists, contact Microsoft Customer Support Services.
21456160Value provided for parameter %s is not valid.
21460160The primary key for source table "%s" includes the timestamp column "%s". Cannot create the article for the specified publication because it allows updating Subscribers.
21481160Cannot create replication subscription(s) in the master database. Choose another database for creating subscriptions.
21482160%s can only be executed in the "%s" database.
21484160Article validation was requested for snapshot publication "%s". Article validation is only valid for transactional publications.
21485160Tracer tokens cannot be posted for a snapshot publication.
21486160An error occurred while logging the tracer token history information. The tracer token could not be posted.
21487160An error occurred while inserting the tracer token to the log. The tracer token could not be posted.
21488160No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token.
21489160A database '%s' already exists. If you intend this to be your distribution database set @existing_db = 1.
21490160The value specified for the %s parameter of sp_mergearticlecolumn must be '%s'. A value of 'true' is allowed only when this procedure is called by another replication procedure. Either set the value of the @schema_replication parameter to 'false' or do not specify a value.
21499160The procedure %s failed to %s the resource %s. Server error = %d.
21500100Invalid subscription type is specified. A subscription to publication '%s' already exists in the database with a different subscription type.
21501100The supplied resolver information does not specify a valid column name to be used for conflict resolution by '%s'.
21502100The publication '%s' does not allow the subscription to synchronize to an alternate synchronization partner.
21503100Cleanup of merge meta data cannot be performed while merge processes are running. Retry this operation after the merge processes have completed.
21504100Cleanup of merge meta data at republisher '%s'.'%s' could not be performed because merge processes are propagating changes to the republisher. All subscriptions to this republisher must be reinitialized.
21505100Changes to publication '%s' cannot be merged because it has been marked inactive.
21506100sp_mergecompletecleanup cannot be executed before sp_mergepreparecleanup is executed. Use sp_mergepreparecleanup to initiate the first phase of merge meta data cleanup.
21507100All prerequisites for cleaning up merge meta data have been completed. Execute sp_mergecompletecleanup to initiate the final phase of merge meta data cleanup.
21508100Cleanup of merge meta data cannot be performed while merge processes are running. Cleanup will proceed after the merge processes have completed.
21509100Cleanup of merge meta data cannot be performed because some republishers have not quiesced their changes. Cleanup will proceed after all republishers have quiesced their changes.
21510100Data changes are not allowed while cleanup of merge meta data is in progress.
21511100Neither MSmerge_contents nor MSmerge_tombstone contain meta data for this row.
21512180%ls: The %ls parameter is shorter than the minimum required size.
21514160Cannot complete the requested operation in the subscription database because a snapshot is currently being delivered to the database. Perform the operation again at a later time. To stop the delivery of the snapshot, stop the Distribution Agent or Merge Agent associated with the subscription.
21515180Replication custom procedures will not be scripted because the specified publication '%s' is a snapshot publication.
21516100Transactional replication custom procedures for publication '%s' from database '%s':
21517100Replication custom procedures will not be scripted for article '%s' because the auto-generate custom procedures schema option is not enabled.
21518100Replication custom procedures for article '%s':
21519100Custom procedures will not be scripted for article update commands based on direct INSERT, UPDATE, or DELETE statements.
21520100Custom procedure will not be scripted because '%s' is not a recognized article update command syntax.
21521160Some generation values are above the upper limit of %d used in SQL Server 2000. Change the publication_compatibility_level of the publication to 90 to make this work.
21522160This article cannot use the '%s' feature because the publication compatibility level is less than 90. Use sp_changemergepublication to set the publication_compatibility_level of publication '%s' to '90RTM'.
21523160Adding column '%s' to table '%s' failed. Articles can have at most %d columns, including columns that have been filtered.
21525160A lightweight replica must be anonymous.
21526160Article '%s' already belongs to a subscription with a different value for the @lightweight property.
21527160Publication '%s' cannot be added to database '%s', because a publication with a lower compatibility level already exists. All merge publications in a database must have the same compatibility level.
21528160Publication '%s' cannot be added to database '%s', because a publication with a higher compatibility level already exists. All merge publications in a database must have the same compatibiliy level.
21530100The schema change failed during execution of an internal replication procedure. For corrective action, see the other error messages that accompany this error message.
21531100The data definition language (DDL) command cannot be executed at the Subscriber. DDL commands can only be executed at the Publisher. In a republishing hierarchy, DDL commands can only be executed at the root Publisher, not at any of the republishing Subscribers.
21532100Cannot add a data definition language trigger for replicating '%.*ls' events.
21533100Cannot insert information into the schema change tracking table sysmergeschemachange.
21535160The article '%s' is already published in another publication, and is set to use nonoverlapping partitions with multiple subscribers per partition (@partition_options = 2). This setting does not permit the article to be included in more than one publication.
21537160The column '%s' in table '%s' is involved in a foreign key relationship with a column in table '%s', but this column was not found in the specified join clause. A logical record relationship between these tables should include this column.
21538160Table '%s' cannot have table '%s' as a parent in a logical record relationship because it already has a different parent table. A logical record relationship allows only one parent table for a given child table.
21539160A logical record relationship, specified by the @filter_type parameter, requires a one-to-one or a one-to-many join from the parent table to the child table. Either change the value of the @filter_type parameter, or set the @join_unique_key parameter to 1.
21540160You cannot drop a column defined as data type uniqueidentifier with the rowguidcol property because merge replication uses this column for tracking. To drop the column, you must first drop the table from all publications and subscriptions.
21541160Cannot complete ALTER TABLE command. Do not execute the command 'ALTER TABLE table_name DISABLE TRIGGER ALL' on a published table. Reissue multiple 'ALTER TABLE table_name DISABLE TRIGGER trigger_name' statements to disable each trigger individually on the given table.
21542160Encountered server error %d while executing <%s>.
21543160The schema for the article %s was either not generated properly or was not applied properly during initial synchronization. This may be due to permissions issues. Verify whether the object exists, and whether the necessary permissions are granted.
21544100Value specified for the publication property replicate_ddl is not valid. The value must be 1 or 0.
21545160You cannot disable a trigger used by merge replication on a published table. To drop the trigger, drop the table from the publication.
21546160Cannot replicate the ALTER TABLE command. It contains multiple DROP commands, including a DROP command for a column that is not included in all subscriptions to this article. Use a single DROP command in each ALTER TABLE command.
21547160Encountered server error %d while restoring the log for database %s.
21548160Cannot execute sp_change_subscription_properties. This stored procedure can only be used for publications that have at least one pull subscription.
21549160Cannot add the computed column '%s' to the publication. You must first add all columns on which this column depends; you cannot filter any of these colunmns from the article.
21550160Before you drop the column from the publication, all computed columns that depend on column '%s' must be dropped.
21551160Only members of the sysadmin or db_owner or db_ddladmin roles can perform this operation.
21552160Merge data definition language (DDL) error: Dropping a column used in a row filter or a join filter is not allowed. To drop a column used in a row filter, first change the row filter using sp_changemergearticle. To drop a column used in a join filter, first drop the join filter using sp_dropmergefilter.
21561160The value specified for parameter %s = %d is not valid.
21564160The table %s contains the column msrepl_tran_version, which is used by replication. The column is set to NULL, but it must be set to NOT NULL. Replication failed to alter this column, so you must drop the column and then add the table as an article again using sp_addarticle. Replication will then add the column to the table.
21567160The call format VCALL cannot be used for the specified article. VCALL format can be used only for articles in publications that allow updating subscriptions. If you do not require updating subscriptions, specify a different call format. If you do require updating subscriptions, you must drop the publication and re-create it to specify that updating subscriptions are allowed.
21569160The article %s in the publication %s does not have a valid conflict table entry in the system table sysarticleupdates. This entry is required for publications that allow queued updating subscriptions. Check for errors in the last run of the Snapshot Agent.
21570160Cannot create the logical record relationship. Table '%s' does not have a foreign key referencing table '%s'. A logical record relationship requires a foreign key relationship between the parent and child tables.
21571160Cannot create the logical record relationship in publication '%s'. The use_partition_groups option for the publication must be set to "true" in order to use logical records. Use sp_changemergepublication to set the option to "true".
21572160Cannot add a logical record relationship because the foreign key constraint '%s' on table '%s' is disabled. To create the logical record relationship, first enable the foreign key constraint.
21573160Cannot add a logical record relationship because the foreign key constraint '%s' on table '%s' is defined with the NOT FOR REPLICATION option. To add the logical record relationship, first drop the foreign key constraint, and then re-create it without the NOT FOR REPLICATION option.
21574160Cannot add a logical record relationship because the article '%s' is published in publication '%s', which has a compatibility level lower than 90RTM. Use sp_changemergepublication to set the publication_compatibility_level to 90RTM.
21575160The value specified for the property filter_type is not valid. Valid values are 1 (join filter only), 2 (logical record relation only), and 3 (join filter and logical record relation).
21576160Cannot add a logical record relationship between tables '%s' and '%s' because the foreign key column '%s' in table '%s' allows NULL values. Alter the column to disallow NULL values.
21578160In order to use partition_options of 2 (non overlapping partitions with multiple subscriptions per partition) or 3 (non overlapping partitions one subscription per partition) the publication '%s' must be enabled to use partition groups functionality. Use sp_changemergepublication to set 'use_partition_groups' to 'true'.
21579160Article "%s" in publication "%s" does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article is involved in multiple join filters. Either select a value of 0 or 1 for the @partition_options parameter, or drop all but one of the join filters by using sp_dropmergefilter.
21580160Article "%s" in publication "%s" does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article is involved in both a row filter and a join filter. Either select a value of 0 or 1 for the @partition_options parameter; drop the join filter by using sp_dropmergefilter; or change the row filter by using sp_changemergepublication.
21581160Article "%s" in publication "%s" does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article has a join filter with a join_unique_key value of 0. Either select a value of 0 or 1 for the @partition_options parameter, or use sp_changemergefilter to specify a value of 1 for join_unique_key.
21582160Article "%s" in publication "%s" does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article has a direct or indirect join filter relationship with parent article "%s". The parent article does not use the same value for partition_options. Use sp_changemergepublication to change the value for one of the articles.
21583160Cannot update the column in article '%s'. The article has a value of 2 or 3 (nonoverlapping partitions) for the partition_options property, and the column is involved in a row filter and/or a join filter. In this situation, the column cannot be updated at a Subscriber or republisher; it must be updated at the top-level Publisher.
21584160Cannot insert the row for article '%s'. The row does not belong to the Subscriber's partition, and the article has a value of 2 or 3 (nonoverlapping partitions) for the partition_options property. Nonoverlapping partitions do not allow out-of-partition inserts.
21585160Cannot specify custom article ordering in publication '%s' because the publication has a compatibility level lower than 90RTM. Use sp_changemergepublication to set the publication_compatibility_level to 90RTM.
21597160The article includes only the rowguidcol column. You must publish at least one other column.
21598160Modifying DDL triggers created by replication is disallowed since these are required to track DDL changes.
21599160The parameters @article and @join_articlename cannot have the same value. Specify different articles for the two parameters; self-joins are not permitted.
21600160Non-SQL Server Publisher [%s] cannot be found. Execute sp_helpdistpublishers to view a list of available Publishers.
21601160The value of the parameter @type must be 'logbased' for Oracle publications.
21603160The refresh of Oracle publisher '%s' by sp_refresh_heterogeneous_publisher was not successful. The Oracle publisher meta data has been retained in its failed state to help in diagnosing the cause of the failure. When the problem has been diagnosed and resolved, rerun sp_refresh_heterogeneous_publisher to complete the refresh.
21604160The non-SQL Server Publisher vendor is not valid. Attempt to add the Publisher again. If the problem persists, contact Microsoft Customer Support Services.
21605160Non-SQL Server Publishers must be configured in the context of the distribution database. Execute sp_adddistpublisher in the context of the distribution database.
21606160Parameter "%s" is for non-SQL Server Publishers only. The value of this parameter must be "%s" for a SQL Server Publisher.
21607160sp_refresh_heterogeneous_publisher was unable to obtain publisher information for Oracle publisher '%s'. sp_refresh_heterogeneous_publisher may only be called to refresh Oracle publishers currently defined at the distributor.
21608160Cannot use a value of TRUE for the parameter @ignore_distributor. The value must be FALSE for a non-SQL Server Publisher.
21609160Non-SQL Server publications do not support updatable subscriptions. The properties allow_sync_tran and allow_queued_tran must be "false".
21610160The failed attempt by sp_refresh_heterogeneous_publisher to refresh publisher '%s' did not alter any meta data at the Oracle publisher. Make certain that the correct Oracle publisher has been identified and that the requirements for refreshing the Oracle publisher have been met.
21611160Cannot drop the distribution Publisher "%s" because it has publications defined. Drop the publications first.
21612160For non-SQL Server Publishers, the value of the @sync_method parameter must be "character" or "concurrent_c".
21613160Constraint column '%s' not found in table '%s'.
21614160Index column '%s' not found in table '%s',
21615160Unable to find table information for article %s. Local distributor cache may be corrupt.
21616160Cannot find column [%s] in the article. Verify that the column exists in the underlying table, and that it is included in the article.
21617160Unable to run SQL*PLUS. Make certain that a current version of the Oracle client code is installed at the distributor. For addition information, see SQL Server Error 21617 in Troubleshooting Oracle Publishers in SQL Server Books Online.
21618160The Publisher '%s' does not exist. To view a list of Publishers, use the stored procedure sp_helpdistpublisher.
21619160Must provide both @SelectColumnList and @InsColumnList.
21620160The version of SQL*PLUS that is accessible through the system Path variable is not current enough to support Oracle publishing. Make certain that a current version of the Oracle client code is installed at the distributor. For addition information, see SQL Server Error 21620 in Troubleshooting Oracle Publishers in SQL Server Books Online.
21621160Unable to create the public synonym %s. Verify that the replication administrative user has been granted the CREATE SYNONYM permission.
21622160Unable to grant SELECT permission on the public synonym %s. Verify that the replication administrative user has sufficient permissions.
21623160Unable to update the public synonym 'MSSQLSERVERDISTRIBUTOR' to mark Oracle instance '%s' as a SQL Server publisher.
21624160Unable to locate the registered Oracle OLEDB provider, OraOLEDB.Oracle, at distributor '%s'. Make certain that a current version of the Oracle OLEDB provider is installed and registered at the distributor. For addition information, see SQL Server Error 21624 in Troubleshooting Oracle Publishers in SQL Server Books Online.
21625160Unable to update the publisher table HREPL_PUBLISHER at the Oracle instance '%s'.
21626160Unable to connect to Oracle database server '%s' using the Oracle OLEDB provider OraOLEDB.Oracle. For addition information, see SQL Server Error 21626 in Troubleshooting Oracle Publishers in SQL Server Books Online.
21627160Unable to connect to Oracle database server '%s' using the Microsoft OLEDB provider MSDAORA. For addition information, see SQL Server Error 21627 in Troubleshooting Oracle Publishers in SQL Server Books Online.
21628160Unable to update the registry of distributor '%s' to allow Oracle OLEDB provider OraOLEDB.Oracle to run in process with SQL Server. Make certain that current login is authorized to modify SQL Server owned registry keys. For addition information, see SQL Server Error 21628 in Troubleshooting Oracle Publishers in SQL Server Books Online.
21629160The CLSID registry key indicating that the Oracle OLEDB Provider for Oracle, OraOLEDB.Oracle, has been registered is not present at the distributor. Make certain that the Oracle OLEDB provider is installed and registered at the distributor. For addition information, see SQL Server Error 21629 in Troubleshooting Oracle Publishers in SQL Server Books Online.
21630160Unable to determine whether the table '%s' is still being published. Contact Customer Support Services.
21631160Cannot unpublish table '%s'; the remote call to the Oracle Publisher failed. Verify that the replication administrative user login can connect to the Oracle Publisher using SQL*PLUS. If you can connect but the problem persists, drop and reconfigure Oracle publishing.
21632160The parameter %s is not supported for non-SQL Server publications. The value specified for this parameter must be %s.
21633160The publication '%s' could not be added because non-SQL Server Publishers only support the @sync_method parameter values "character" or "concurrent_c".
21634160The parameter %s does not support the value '%s' when using non-SQL Server publications. The value must be %s.
21635160An unsupported schema option combination was specified. Non-SQL Server publications only support the following schema options: 0x01, 0x02, 0x10, 0x40, 0x80, 0x4000, and 0x8000.
21637160%s is required for heterogeneous publications.
21638160You have specified a value of '%s' for the @repl_freq parameter of sp_addpublication. For non-SQL Server publications, this requires one of the following values for the @sync_method parameter: %s.
21639160Heterogeneous publishers can not use trusted connections, set @trusted to false.
21640160Non-SQL Server Publishers do not support a value of 1 for the parameter @thirdparty_flag. When executing the stored procedure sp_adddistpublisher, specify a value of 0 for the parameter.
21641160The "%s" parameter is for non-SQL Server Publishers only. It must be NULL for SQL Server Publishers.
21642160Heterogeneous publishers require a linked server. A linked server named '%s' already exists. Please remove linked server or choose a different publisher name.
21643160The value specified for the parameter '%s' must be MSSQLSERVER, ORACLE, or ORACLE GATEWAY.
21644160%s value of '%s' is not supported for heterogeneous subscribers, must be %s.
21645160The value '%s' is not a valid non-SQL Server Publisher type. For SQL Server 2005, the value must be ORACLE or ORACLE GATEWAY.
21646160The Oracle server [%s] is already defined as the Publisher [%s] on the Distributor [%s].[%s]. Drop the Publisher or drop the public synonym [%s].
21647160The Oracle Publisher support package could not be loaded. Drop the replication administrative user schema and re-create it; ensure it is granted the documented permissions.
21649160Cannot change the property '%s'. Non-SQL Server Publishers do not support this property.
21650160The value specified for @rowcount_only for the article '%s' is not 1. For an article in a publication from a non-SQL Server Publisher, 1 is the only valid setting for this parameter.
21651160Failed to execute the HREPL.%s request to Oracle Publisher '%s'. Verify that the Oracle package code exists on the Publisher, and that the replication administrative user account has sufficient permissions.
21653160The database management system (DBMS) %s %s does not exist. Verify the supported DBMS and versions by querying msdb.dbo.MSdbms.
21654160The data type %s does not exist. Verify the supported data types and mappings by querying msdb.dbo.sysdatatypemappings.
21655160The data type %s already exists.
21656160The data type mapping for %s does not exist. Verify the list of available mappings by querying msdb.dbo.sysdatatypemappings.
21657160The data type mapping for %s already exists.
21658160The data type mapping does not exist. Verify the list of mappings by querying msdb.dbo.sysdatatypemappings.
21659160Cannot execute this procedure for a SQL Server Publisher. The Publisher must be a non-SQL Server Publisher.
21660160The value specified for the parameter @full_or_fast for article '%s' must be 0, 1, or 2.
21661160The value specified for the @shutdown_agent parameter for article '%s' must be 0 or 1.
21662160The source object [%s].[%s] on the non-SQL Server Publisher was either not found or is not supported. If the object exists, verify that it meets the requirements for being published.
21663160Cannot find a valid primary key for the source table [%s].[%s]. A valid primary key is required to publish the table. Add or correct the primary key definition on the source table.
21664160Index [%s] contains unique nullable column.
21665160Key [%s] contains unique nullable column.
21666160Cannot specify more than %d column names for the index or primary key because this exceeds the maximum number of columns supported by SQL Server. %d columns were specified.
21667160The index "%s" was not created. The index has a key length of at least %d bytes. The maximum key length supported by SQL Server is %d bytes.
21668160The constraint "%s" was not created because one or more columns in the constraint is not published. Either include all columns in the published article, or alter the constraint to remove columns that are not published.
21669160Column [%s] cannot be published because it uses an unsupported data type [%s]. View supported data types by querying msdb.dbo.sysdatatypemappings.
21670160Connection to server [%s] failed.
21671160Cannot execute the procedure. Administration of a non-SQL Server Publisher must be performed at the associated SQL Server Distributor. Execute the procedure at the Distributor.
21672160The login '%s' has insufficient authorization to execute this command.
21673160Test connection to publisher [%s] failed. Verify authentication information.
21674160Unable to update the linked server [%s] for the login [%s].
21675160Cannot specify more than %d indexes for a single table. %d indexes specified. Excess indexes have been ignored.
21676160Heterogeneous subscriber '%s' could not add a subscription for heterogeneous publication '%s' because publication sync method is not 'character', 'concurrent_c', or 'database snapshot character'.
21677160Heterogeneous publisher '%s' cannot be defined as a subscriber.
21678160The parameter "%s" can be set to "%s" only when "%s" is set to "%s".
21679160Peer-to-peer publications only support a '%s' parameter value of %s.
21680160The Distribution Agent was unable to update the cached log sequence numbers (LSNs) for Originator %s, OriginatorDB %s, OriginatorDBVersion %d, OriginatorPublicationID %d. Stop and restart the Distribution Agent. If the problem persists, contact Customer Support Services.
21681160The current user '%s' does not have a valid linked server login mapping for non-SQL Server Publisher [%s]. Replication connects to the Publisher through a linked server; use the stored procedure sp_addlinkedsrvlogin to map the user's login to this linked server.
21682160Cannot publish table [%s].[%s]. The replication administraive user requires an explicit SELECT grant, or a SELECT grant through PUBLIC, in order to publish this table. A role-based SELECT grant, if one exists, is not sufficient.
21683160Cannot verify administrator login privileges for Oracle Publisher %s. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS.
21684160The replication administrative user for Oracle Publisher "%s" has insufficient permissions. Refer to the script /MSSQL/Install/oracleadmin.sql for the required permissions.
21685160Request '%s' for Oracle schema filter for Oracle publisher '%s' failed.
21686160The operation "%s" is not valid. Valid operations are "add", "drop", and "help".
21687160Schema filters are supported only for Oracle Publishers. The Publisher "%s" is a "%s" Publisher.
21688160The current login '%s' is not in the publication access list (PAL) of any publication at Publisher '%s'. Use a login that is in the PAL, or add this login to the PAL.
21689160A NULL @schema value is invalid for add and drop schema filter operations.
21690100The subscriber db cannot be the same as the publisher db when the subscriber is the same as the publisher
21691100sp_mergesubscription_cleanup should be called on the subscription database
21692160Failed to script the subscriber stored procedures for article '%s' in publication '%s'
21694160%s cannot be null or empty when %s is set to 0 (SQL Server Authentication). Specify a login or set security mode to 1 (Integrated Authentication).
21695100The replication agent job '%s' was not removed because it has a non-standard name; manually remove the job when it is no longer in use.
21696160The stored procedure only applies to Oracle Publishers. The Publisher '%s' is a %s Publisher.
21698160The parameter '%s' is no longer supported.
21699100Unable to reuse view '%s' because it was not found. Re-creating all system table views. This is an informational message only. No user action is required.
21701160Microsoft SQL Server Additive Conflict Resolver
21702160Microsoft SQL Server Averaging Conflict Resolver
21703160Microsoft SQL Server DATETIME (Earlier Wins) Conflict Resolver
21704160Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver
21705160Microsoft SQL Server Download Only Conflict Resolver
21706160Microsoft SQL Server Maximum Conflict Resolver
21707160Microsoft SQL Server Merge Text Columns Conflict Resolver
21708160Microsoft SQL Server Minimum Conflict Resolver
21709160Microsoft SQL Server Priority Column Resolver
21710160Microsoft SQL Server Subscriber Always Wins Conflict Resolver
21711160Microsoft SQL Server Upload Only Conflict Resolver
21712160Microsoft SQLServer Stored Procedure Resolver
21715160Cannot register the article resolver %s. This can occur if the account under which SQL Server is running does not have access to the distribution database. Add the class ID and the custom resolver name manually to the MSmerge_articleresolver table in the distribution database.
21717160The article resolver name cannot be an empty string or NULL. Specify a valid value for the @article_resolver parameter.
21718160For a COM resolver, the @resolver_clsid cannot be an empty string or NULL. Specify a valid value for @resolver_clsid.
21719100The Subscriber '%s':'%s' was not marked for reinitialization at the Publisher because the subscription is either anonymous or not valid. Verify that valid values were specified for the @subscriber and @subscriber_db parameters of sp_reinitmergesubscription.
21720160Cannot find a job that matches the ID or name specified in the parameters @dynamic_snapshot_jobid or @dynamic_snapshot_jobname. Verify the values specified for those parameters.
21721100UserScripts
21722160Failed to add an extended trigger for replicating the '%.*ls' event.
21723160The value specified for the @pubid parameter of procedure '%s' is not valid or is NULL. Verify that the Merge Agent is running correctly. Reinitalize the subscription if the problem persists.
21724100Cannot add the foreign key %s with the CASCADE option because table %s is published. Add the NOT FOR REPLICATION clause to the foreign key definition.
21725160Cannot alter the view. An indexed view replicated as a table cannot be altered to a nonindexed view. Drop the view from the publication before attempting to alter it.
21727140Cannot complete the replication operation. The security check for the current user is failing. Only members of the sysadmin fixed server role, or db_owner or db_ddladmin fixed database roles can perform this operation.
21728160The article can support logical record level conflict detection only if it uses logical record conflict resolution.
21729160The @keep_partition_changes property cannot be set to "true." This is because the @publication_compatibility_level property is set to 90RTM or higher and the @use_partition_groups property is set to "true." Set a lower compatibility level or set the @use_partition_groups property to "false."
21730160Table '%s' can not be replicated because it contains imprecise Primary Key column, please recreate table without 'persisted' clause and try again.
21731160Cannot add a constraint or default without an explicit name, because the table is included in a publication that replicates DDL events. Specify a unique name for the constraint and then reissue the DDL statement.
21732160Using Data Transformation Services (DTS) packages in replication requires a password that is not NULL or empty. Specify a valid value for parameter '%s'.
21733160Cannot open database %s. The upgrade of replication %s could not be performed. Run %s again from the %s database when the %s is accessible.
21734160Peer-to-peer publications do not support replicating timestamp columns as varbinary(8). You cannot add an article with this option, nor add or alter a table to include a timestamp column as varbinary(8).
21735160Source object [%s].[%s] is a temporary object and cannot be published.
21736160Unable to relocate the article log table to a different tablespace. Verify that the replication administrative user login can connect to the Oracle Publisher using SQL*PLUS. If you can connect, but the problem persists, it might be caused by insufficient permissions or insufficient space in the tablespace; check for any Oracle error messages.
21737160The property '%s' is not valid for '%s' Publishers.
21738160The property '%s' is not valid for %s publications.
21739160Cannot alter property '%s'. You must first call the stored procedure sp_articleview to initialize the article; the property can then be altered.
21740160Oracle subscriber '%s' not found. Loopback support cannot be checked.
21741160Unable to retrieve distributor information from Oracle publisher '%s'. Bi-directional publishing requires Oracle publisher to exist before the Oracle subscriber.
21742160The Oracle Publisher name is '%s' and the Oracle Subscriber name is '%s'. Bidirectional Oracle publishing requires the Oracle Publisher and Subscriber names to be the same.
21743160Unable to retrieve the originator information for the Oracle subscriber '%s'.
21744160Oracle bidirectional publishing requires parameter '%s' to have a value of '%s'.
21745160Cannot generate a filter view or procedure. Verify that the value specified for the @filter_clause parameter of sp_addarticle can be added to the WHERE clause of a SELECT statement to produce a valid query.
21746160The '%s' character length must not exceed %d.
21747160Cannot establish a connection to the Oracle Publisher '%s'. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS.
21748160The article was dropped at the Distributor, but information at the Publisher '%s' was not dropped. No action is required; the information is cleaned up if the Publisher is dropped.
21749160The Publisher was dropped at the Distributor, but information on the Publisher '%s' was not dropped. Connect to the Oracle Publisher with SQL*PLUS and drop the replication administrative user.
21750160The table %s does not have a primary key, which is required for transactional replication. Create a primary key on the table.
21751160Cannot publish view %s as a table because it does not have a unique clustered index. Publish the view as a view, or add a unique clustered index.
21752160The current user %s does not have SELECT permission on the table %s. The user must have SELECT permission to retrieve rows at the Subscriber that have updates pending in the queue.
21753160The table %s, which is specified in the @tablename parameter of sp_getqueuedrows, is not part of any active initialized queued subscription. Ensure your queued subscriptions are properly initialized by running the Snapshot Agent, Distribution Agent, and Queue Reader Agent.
21754160Processing has been terminated. The resultset for sp_getqueuedrows is larger than 16,000, the maximum size that the procedure can return. Run the Queue Reader Agent to flush the queue at the Subscriber before executing this procedure again.
21755160Failed to mark '%s' as a system object.
21756160Based on article settings, table %s should have an identity column, but it does not have one. Verify article settings with sp_helparticle and change them if necessary with sp_changearticle.
21757160The subscription is read-only. The publication that this subscription synchronizes with allows updates at the Subscriber, but a value of 'read-only' was specified for the @update_mode parameter of sp_addsubscription. To allow updates, you must drop and then re-create the subscription, specifying a different value for @update_mode.
21758160Cannot find a valid Queue Reader Agent ID for the subscription to Publisher %s, database %s, publication %s. The specified subscription to an updating Subscriber publication is not initialized. Run the Snapshot Agent, Distribution Agent, and Queue Reader Agent to initialize the subscription.
21759160Cannot 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).
21760110Cannot execute the replication script in the 'master' database; the current session will be terminated. The script must be executed in the distribution database, and the master database cannot serve as the distribution database.
21761200Cannot execute the replication script; the current session will be terminated. Check for any errors returned by SQL Server during execution of the script.
21762100The distribution database '%s' has a compatibility level of %d, which is different from that of the master database. The two compatibility levels must be the same, so the distribution database level is being changed to %d. This is an informational message only. No user action is required.
21763160Message Queuing Service is not running. Start this service and retry the operation.
21764160Cannot create the publication. Specifying a value of 'msmq' for the parameter @queue_type is supported only on Microsoft Windows NT platforms. Specify a value of 'sql' for this parameter.
21765100The column msrepl_tran_version has been predefined and allows NULLs. This column will be dropped and recreated to not allow NULLs for updating subscribers.
21766160Table %s contains an identity column that is marked as Not For Replication, but the @identitymanagementoption parameter of sp_addarticle is set to 'none'. To support immediate updating subscriptions, specify a value of 'manual' or 'auto' for @identitymanagementoption.
21767100Warning: The parameter '%s' is obsolete and is available only for backwards compatibility. It will not be available in future releases. Instead of this parameter, use the parameter '%s'.
21768160When executing sp_adddistributor for a remote Distributor, you must use a password. The password specified for the @password parameter must be the same when the procedure is executed at the Publisher and at the Distributor.
21769100Custom data type mappings are not supported. You must validate the correctness of the mapping. If mappings are not compatible, errors will likely occur when moving data from the Publisher to the Subscriber.
21770100Data type mapping from '%s' to '%s' does not exist. Review source and destination data type, length, precision, scale, and nullability. Query the system table msdb.dbo.sysdatatypemappings for a list of supported mappings.
21771160%s is not within the supported range of %d and %d.
21772160Property "%s" requires the parameters @force_invalidate_snapshot and @force_reinit_subscription to be set to "true".
21773100The distribution database '%s' cannot be opened due to inaccessible files. The database will be dropped, but distribution database cleanup tasks will not occur. Check the database and server error logs for more information about why the database files cannot be accessed.
21774160This procedure is supported only for non-SQL Server Publishers. The Publisher '%s', on which you are executing the procedure, is a SQL Server Publisher.
21775160Failed to generate column bitmap for article '%s'.
21776160Failed to generate published column bitmap for article '%s'.
21777160Failed to generate article view name for article '%s'.
21778160Cannot add Publisher objects to the Oracle Publisher for article '%s'. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS. Ensure that the replication administrative user schema has the required permissions.
21779100Cannot use the specified data type mapping. The matching destination data type for source type %s cannot be found. Query the system table msdb.dbo.sysdatatypemappings for a list of supported mappings. Verify that the length, precision, scale, and nullability of the source type are correct.
21780160The non-SQL Server Publisher is missing one or more %s objects. Drop and re-create the Publisher and the replication administrative user schema.
21781160Unable to retrieve heterogeneous metadata. Verify connection information
21782160Cannot add primary key column '%s' to article '%s'. If the Publisher is a non-SQL Server Publisher, the primary key could have violated SQL Server limits for number and length of columns. For more information, see errors returned by sp_addarticle.
21783160Cannot add the Publisher triggers and the article log table to the Oracle Publisher for the article '%s'. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS. Ensure that the replication administrative user schema has the required permissions.
21784160You must specify a non-NULL value for the @rowfilter parameter.
21785160Failure to query Oracle XactSet Job attributes for publisher '%s'.
21786160Failure to refresh Oracle XactSet Job for publisher '%s'.
21787160Failure to query Oracle Xact batching enabled flag for publisher '%s'.
21788160Invalid parameter passed to sp_IHSetXactBatching. The bit flag to enable/disable Xact batching must be 0 or 1.
21789160Failure to set the Oracle Xact batching enabled flag for publisher '%s'.
21790160Cannot publish the table '%s.%s' from the Publisher '%s'. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS. Ensure that the replication administrative user schema has the required permissions.
21791160The table '%s.%s' already appears in a transactional publication on Oracle Gateway Publisher '%s'. When using the Oracle Gateway option, a table published using transactional replication can only be included in one publication. To publish this table in more than one publication, you must reconfigure the Oracle Publisher to use the Oracle Complete option.
21792160The table '%s.%s' already appears in the transactional publication '%s' on Publisher '%s'. The Oracle Gateway publishing option (the default) allows a table to be included as an article in any number of snapshot publications, but only in one transactional publication. To publish a table in more than one transactional publication, use the Oracle Complete publishing option. To change publishing options, you must drop and reconfigure the Publisher.
21793160Non-SQL Server Publishers are supported only in the Enterprise and Developer editions of SQL Server. The edition of this instance is %s.
21794160The value specified for the @propertyname parameter is not valid. Use one of the following values: %s.
21795160The value specified for property %s is not valid. Use one of the following values: %s.
21796160The property "xactsetjobinterval" must be assigned a value greater than or equal to 0.
21797160Cannot create the agent job. '%s' must be a valid Windows login in the form : 'MACHINELogin' or 'DOMAINLogin'. See the documentation for '%s'.
21798160Cannot execute the replication administrative procedure. The '%s' agent job must be added through '%s' before continuing. See the documentation for '%s'.
21799160The %s agent for Publisher (%s), database (%s), publication (%s) cannnot be found. Create the agent with the appropriate procedure: sp_addpublication_snapshot, sp_addlogreader_agent, or sp_addqreader_agent.
21800160The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up.
21801160The stored procedure sp_createagentparameter failed to add one or more parameters to the system table msdb.dbo.MSagentparameterlist. Check for any errors returned by sp_createagentparameter and errors returned by SQL Server during execution of sp_createagentparameter.
21802160The agent profile creation process cannot validate the specified agent parameter value. '%s' is not a valid value for the '%s' parameter. The value must be an integer less than or equal to '%d'. Verify that replication is installed properly.
21803160Cannot update agent parameter metadata. Replication could not insert parameter '%s' into table '%s'. Verify that replication is properly installed. Check errors returned by SQL Server during execution of sp_createagentparameter.
21804160The value '%d' specified for the @agent_type parameter of sp_getagentparameterlist is not valid. Specify a valid value of 1, 2, 3, 4, or 9.
21805160The agent profile creation process cannot validate the specified agent parameter value. '%s' is not a valid value for the '%s' parameter. The value must be an integer. Verify that replication is installed properly and that sp_add_agent_parameter is invoked with a valid value.
21806160The agent profile creation process cannot validate the specified agent parameter value: the profile_id %d does not exist or it does not support the parameter %s. The value must be an integer. Verify that replication is installed properly and that sp_add_agent_parameter is invoked with a valid value.
21807160For a .NET Assembly Business Logic Handler, the @resolver_clsid must be specified as NULL.
21808160For a .NET Assembly Business Logic Handler, the @resolver_info must contain the class name in '%s' that implements the Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule interface.
21809100DDL replication is not enabled for database '%ls' because its compatibility level is less than 80.
21810160Identity column can only be added to a published table with 'Not For Replication' clause
21811160Cannot drop the column '%s' because it is used by replication: it is referenced in a filter or view by article '%s'. To drop the column, you must first remove the filter from the article.
21812160Cannot perform "Disable Trigger All" on table %s because it belongs to a publication that supports updatable subscriptions (replication adds triggers to tables for these types of publications). You may, however, disable user triggers individually. Specify an individual user trigger name to disable.
21813160Can not disable trigger %s on table %s because it is required by updatable publication.
21814160DDL replication failed to refresh custom procedures, please run "exec sp_register_custom_scripting 'CUSTOM_SCRIPT', your_script, '%s', '%s' "and try again
21815160Can not alter replicated object '%s' to 'with encrypted'.
21816160An invalid value was specified for parameter '%s'. The value must be '%s' when changing this property.
21817160The property '%s' is only valid for push subscriptions.
21818100The parameters for security, batch size, and scheduling have been deprecated and should no longer be used. For more information, see the "sp_addsubscriber" documentation.
21819160Cannot change the property '%s' . This property is only valid for subscriptions that allow updating at the Subscriber. The subscription against which the procedure was called does not allow updates at the Subscriber.
21820160Cannot write to the script file in the snapshot folder at the Distributor (%ls). Ensure that there is enough disk space available. Also ensure that the account under which the Snapshot Agent runs has permissions to write to the snapshot folder and its subdirectories.
21821160Specify one and only one of the parameters - %s or %s.
21822160Cannot perform %s on %s as entry already exists.
21823160Cannot perform %s on %s as entry does not exist.
21824160Can not add constraints to multiple columns because table %s is published but column %s is not in all active partitions, please use separate DDL statement.
21825160Can not drop constraints in the same DDL statement which drops columns from table %s because the table is published, please use separate DDL statement.
21826160The property '%s' is valid only for %s subscriptions. Use '%s' for %s subscriptions.
21827160The %s parameters have been deprecated and should no longer be used. For more information, see the '%s' documentation.
21828160The proxy account for jobstep_uid (%s) could not be found.
21830160You cannot specify schema_option 0x4 (script identity as identity rather than the base data type) for article '%s'. The value specified for the parameter @identityrangemanagementoption is NONE. To replicate identity as identity, the value must be MANUAL or AUTO for publications that do not support queued updating subscriptions.
21831160The %s already exists. Use '%s' to change any settings/properties.
21832160Only members of the sysadmin fixed server role can perform this operation without specifying %s.
21833160An error occurred when creating a trace event at Oracle publisher '%s'. The trace event could not be posted.
21834160The primary key for '%s.%s' has %d columns. SQL Server supports a maximum of %d columns. Redefine the primary key so that it has no more than the maximum number of columns.
21835160The index for the primary key '%s.%s' is at least %d bytes. SQL Server supports a maximum key length of %d bytes. Reduce the number of columns in the primary key or redefine the columns to use smaller data types.
21836160The distribution agent must be run in single subscription stream mode prior to resetting the subscription xact_seqno.
21837160A replication agent job (%s) for this subscription already exists.
21838160The %s parameter(s) have been deprecated from this procedure. The value(s) should now be specified when calling '%s'.
21839160Article '%s' can not support schema_option 0x20 or 0x2000000000 because it contains computed column, check/default constraint or primary key which is based on CLR type column, change @schema_option setting and try again.
21840160Can not add CLR type based computed column or check constraint to table '%s' because article '%s' supports schema_option 0x20.
21841100DDL replication is forcing reinitialization because either publication'%s' uses character mode bcp, or timestamp/identity column is being replicated as base type only for article '%s'.
21842160%s can only be specified/changed for heterogeneous publications when %s is set to %s.
21843160Article '%s' can not be added, an indexed view published as 'indexed view logbased' and a stored procedure in either form of 'proc exec' can not be published if their common base table is also published.
21844160Can not alter XML, CLR type or MAX type column because table is published and article '%s' supports the schema option to map this to a base column type.
21845160Can not alter procedure '%s' to depend on an indexed view published as 'indexed view logbased' or a base table because the indexed view depends on this table as well.
21846160Cannot find a distribution agent job for the specified transactional or snapshot push subscription.
21847160Cannot find a merge agent job for the specified merge push subscription.
21848160The specified pull subscription is not configured with a synchronization agent job.
21850160The property "%s" cannot be changed to "%s" after the value has already been set to "%s".
21851160Peer-to-peer publications only support a "%s" value of %s. Article "%s" currently has a "%s" value of %s. This value must be changed to continue.
21852160Peer-to-peer publications do not support %s. Article "%s" currently has %s. This must be changed to continue.
21853100Warning: The "%s" property for %s "%s" has been changed to "%s" because it is required by %s.
21854100Could not add new article to publication '%s' because of active schema change activities or a snapshot is being generated.
21855160The login %s provided in sp_link_publication is not mapped to any user in publishing database %s.
21856160For a .NET Assembly Business Logic Handler, the .NET Assembly name should be the name of a valid assembly in '%s' that contains the class that implements the Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule interface. Check the registration of the business logic handler to make sure the .NET Assembly name was specified correctly.
21857100Forcing re-initialization for article '%s' in publication '%s', the clustered index on indexed view '%s' may have been dropped by upgrade or restore process, please re-create the index and re-sync your data.
21858160Snapshot can not process article '%s' in publication '%s', the clustered index on indexed view '%s' may have been dropped by upgrade or restore process, please re-create the index and re-run snapshot.
21859160Cannot change subscription property '%s' because there is no entry for this subscription in the MSsubscription_properties table. Call sp_addmergepullsubscription_agent before changing this property.
21860100Table '%s' in database '%s' is subscribing to transactional queued publication and published for merge for uploading changes, this may cause non-convergence between transactional publisher and subscriber.
21861160The current operation was aborted because it would deactivate an article in a publication for which a snapshot was being generated.
21862160FILESTREAM columns cannot be published in a publication by using a synchronization method of either 'database snapshot' or 'database snapshot character'.
21863160Cannot add the SPARSE property to a column for the article '%s' because merge replication does not support sparse columns.
21864160Cannot publish the article '%s' or add the COLUMN_SET attribute set to its base table '%s' because replication does not support column sets.
21865160The '%s' publication property must be either 'true' or 'false'.
21866160The publication property '%s' can only be set to '%s' when the publication property '%s' is set to '%s'.
21867160ALTER TABLE SWITCH statement failed. The table '%s' belongs to a publication which does not allow switching of partitions
21868160ALTER TABLE SWITCH statement failed. The statement is not allowed because one or more of the tables in this statement is an article with a different destination table or owner.
21869160Cannot add filter between proposed parent article '%s' and proposed child article '%s' since this would introduce a cycle in the filter relationships. The proposed parent is already being filtered by the child.
21870161Distribution agent encountered a deadlock while applying commands in SubscriptionStreams mode. Spid %u waiting on lock (type '%s', mode '%s') for index '%s' of table '%s'.
21871160Publisher %s of database %s has not been redirected.
21872160The availability group associated with Virtual Network Name '%s' has no replicas.
21873160You are not authorized to run the stored procedure %s.
21874160The stored procedure %s must be run from a distirbution database. The current database %s is not a distribution database.
21875160The parameters @original_publisher and @publisher_db to stored procedure '%s' may not be NULL.
21876160The distributor '%s' is not the distributor for original publisher '%s' and publisher database '%s'.
21877160The original publisher '%s' for database '%s' is not a remote server for the distributor.
21878160Unable to create a linked server to use in contacting the remote publisher for original publisher '%s', publisher database '%s', and redirected publisher '%s'. The command '%s' failed with Error '%d', Error Message '%s'.
21879160Unable to query the redirected server '%s' for original publisher '%s' and publisher database '%s' to determine the name of the remote server; Error %d, Error message '%s'.
21880160The virtual network name '%s' has been used to identify the redirected publisher for original publisher '%s' and database '%s'. The availability group associated with this virtual network name, however, does not include the publisher database.
21881160The database '%s' at the redirected publisher '%s' for original publisher '%s' and database '%s' is either not synchronized or is not active.
21882160The database '%s' at the redirected publisher '%s' for original publisher '%s' and database '%s' belongs to a HADRon availability group and must be redirected to its associated HADRon Virtual Network Name.
21883160The query at the redirected publisher '%s' to determine whether the publisher database '%s' belonged to an availability group failed with error '%d', error message '%s'.
21884160The query at the redirected publisher '%s' to determine the health of the availability group associated with publisher database '%s' failed with error '%d', error message '%s'.
21885160The return code of the failed call was '%d'.
21886160The remote server name returned was null.
21887160The query at the redirected publisher '%s' to determine whether the publisher database '%s' belonged to an availability group failed with error '%d', error message '%s'.
21888160The SQL Server instance '%s' is not configured to support replication. To enable the SQL Server instance to serve as a replication publisher, configure the instance for replication.
21889160The SQL Server instance '%s' is not a replication publisher. Run sp_adddistributor on SQL Server instance '%s' with distributor '%s' in order to enable the instance to host the publishing database '%s'. Make certain to specify the same login and password as that used for the original publisher.
21890160The SQL Server instance '%s' with distributor '%s' and distribution database '%s' cannot be used with publisher database '%s'. Reconfigure the publisher to make use of distributor '%s' and distribution database '%s.
21891160The publisher '%s' with distributor '%s' is not known as a publisher at distributor '%s'. Run sp_adddistpublisher at distributor '%s' to enable the remote server to host the publishing database '%s'.
21892160Unable to query sys.availability_replicas at the availability group primary associated with virtual network name '%s' for the server names of the member replicas: error = %d, error message = %s.',
21893160The subscribers ( %s ) of original publisher '%s' do not appear as remote servers at redirected publisher '%s'. Run sp_addlinkedserver at the redirected publisher to add these subscribers as remote servers.
21894160Unable to configure a linked server to query replica host server '%s': return code = %d.
21895160One or more publisher validation errors were encountered for replica host '%s'.
21896160The query at the redirected publisher '%s' to determine whether the SQL Server instance is a replication publisher failed with error '%d', error message '%s'.
21897160The query to determine whether the local distributor '%s' is the distributor for remote publisher '%s' failed with error '%d', error message '%s'.
21898160The publisher '%s' uses distribution database '%s' and not '%s' which is required in order to host the publishing database '%s'. Run sp_changedistpublisher at distributor '%s' to change the distribution database used by the publisher to '%s'.
21899160The query at the redirected publisher '%s' to determine whether there were sysserver entries for the subscribers of the original publisher '%s' failed with error '%d', error message '%s'.