Browse Site by Tags - MSMVPS.COM

FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Some changes from subscribers who use SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-24-2007
Filed under: sql server, web, replication, kba, merge, subscriber, publisher, compact edition, synchronization, ce

FIX: Error message when you create a new subscription to a report in SQL Server 2005 Reporting Services: "Error: Object expected"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error message when you create a new subscription to a report in SQL Server 2005 Reporting Services: "Error: Object...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-12-2007
Filed under: sql server, kba, error log, subscriber, reporting services, report

FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 09-11-2007
Filed under: sql server, replication, kba, process, subscriber, publisher, broker

FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: "Must declare the scalar variable "@Variable""

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-20-2007
Filed under: sql server, kba, variable, snapshot, subscriber

FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Data is not replicated to a subscriber in a different partition by using parameterized row...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-19-2007
Filed under: sql server, replication, kba, subscriber, parameter

FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-30-2007
Filed under: sql server, replication, kba, merge, subscriber, publisher