sql-serer-errorTag Archive

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Agent profile for skipping data consistency errors. It can be used only by SQL Server Subscribers.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: You do not have permissions to run agents for push subscriptions. Make sure that you specify the agent parameter ‘SubscriptionType’.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Invalidated the existing snapshot of the publication. Run the Snapshot Agent again to generate a new snapshot.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot make the change because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force the change and invalidate the existing snapshot.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot make the change because there are active subscriptions. Set @force_reinit_subscription to 1 to force the change and reinitialize the active subscriptions.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot add the article. Publications that allow transformable subscriptions with Data Transformation Services (DTS) can only include tables and indexed views that are published as tables.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot attach subscription file ‘%s’. Make sure that it is a valid subscription copy file.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Checksum validation is not supported because the publication allows DTS. Use row count only validation.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Validation is not supported for articles that are set up for DTS horizontal partitions.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Unable to add a heterogeneous subscription to the publication. The publication is not enabled for heterogeneous subscriptions.