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

ID: Q232522


The information in this article applies to:

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 

Last Reviewed: June 23, 1999