BUG: SEM Does Not Allow You to Indicate Manual Sync Complete

• Microsoft SQL Server, version 6.0

SYMPTOMS

Under Manage Replication\Subscriptions, SQL Enterprise Manager allows you to subscribe to a publication using manual synchronization. After manually synchronizing the tables, when you look up the Manage Replication\ Subscriptions option to indicate completion of manual sync, the "Sync Completed" is not available (greyed out).

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

SQL Enterprise Manager incorrectly disables the "Sync Complete" option and the articles initially say "Not Sync'ed." After some variable length of time, they change to "Sync'ed." The time duration depends on the activity on the subscription server.

In essence, a manual sync does not allow you to signal the completion of manual synchronization and incorrectly indicates that the table is sync'ed. In SQL Enterprise Manager for SQL Server version 6.5, it stays at "Not- sync'ed" and does not allow you to signal completion of manual sync.