SQL Server Errors or Failures from Error: 21145 to Error: 21164

SQLServerF1

 

Error: 21145, Severity: 16, Cannot subscribe to publication %s because the Subscriber has a subscription to a publication of sync_type ‘dump database’.
Error: 21146, Severity: 16, @use_ftp cannot be ‘true’ while @alt_snapshot_folder is neither NULL nor empty.
Error: 21147, Severity: 16, The ‘%s’ database is not published for merge replication.
Error: 21148, Severity: 16, Both @subscriber and @subscriberdb must be specified with non-null values simultaneously, or both must be left unspecified.

Error: 21149, Severity: 16, The ‘%s’ database is not published for transactional or snapshot replication.
Error: 21150, Severity: 16, Unable to determine the snapshot folder for the specified subscription because the specified Subscriber is not known to the Distributor.
Error: 21151, Severity: 16, Pre- 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.

Error: 21152, Severity: 16, Cannot create a subscription of sync_type ‘none’ to a publication using the ‘concurrent’ or ‘concurrent_c’ synchronization method.
Error: 21153, Severity: 16, Cannot create article ‘%s’. All articles that are part of a concurrent synchronization publication must use stored procedures to apply changes to the Subscriber.
Error: 21154, Severity: 16, Cannot change article ‘%s’. All articles that are part of a concurrent synchronization publication must use stored procedures to apply changes to the Subscriber.
Error: 21155, Severity: 16, Cannot change article ‘%s’. articles that are part of a concurrent synchronization publication can not have ins_cmd/del_cmd which exceeds %d characters .
Error: 21156, Severity: 16, The @status parameter value must be ‘initiated’ or ‘active’.
Error: 21157, Severity: 16, The snapshot compression option can be enabled only for a publication having an alternate snapshot generation folder defined.
Error: 21158, Severity: 16, For a publication to be enabled for the Internet, the ‘ftp_address’ property must not be null.
Error: 21159, Severity: 16, If a publication is enabled for the Internet, the ‘alt_snapshot_folder’ property must be non-empty.
Error: 21160, Severity: 16, The ‘ftp_port’ property must be a non-negative integer < 65536.
Error: 21161, Severity: 16, Could not change the Publisher because the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggers.
Error: 21162, Severity: 16, It is invalid to exclude the rowguid column for the table from the partition.
Error: 21163, Severity: 16, It is not possible to add column ‘%s’ to article ‘%s’ because the snapshot for publication ‘%s’ has been run.
Error: 21164, Severity: 16, Column ‘%s’ cannot be included in a vertical partition because it is neither nullable nor defined with a default value.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *