FIX: Error 16943 When Dropping Pull Subscription with 'ALL' as Parameter Value

ID: Q232522

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 53658 (SQLBUG_70)

SYMPTOMS

The following error message is returned when you try to drop a Pull subscription using sp_droppullsubscription with 'ALL' as the parameter value for any of the parameters:

Server: Msg 16943, Level 16, State 1, Procedure sp_droppullsubscription
Could not complete cursor operation because the table schema changed after the cursor was declared.

However, the subscriptions are dropped correctly.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

The error message can be ignored since the subscriptions are dropped correctly.

REFERENCES

For more information on sp_droppullsubscription, refer to SQL Server Books Online.

Additional query words: Error 16943, Replication, Subscription

Keywords : kbbug7.00 kbSQLServ700bug kbSQLServ700sp1fix
Version : winnt:7.0
Platform : winnt
Issue type : kbbug