Groups | Blog | Home
all groups > sql server clients > april 2004 >

sql server clients : sp_dropsubscription


Noorali Issani
4/2/2004 9:34:37 AM
I have used the following commands for removing the article, first command
executed sucessfully but second command gave me an error, can any body tell
me ?

sp_dropsubscription 'LMS' , 'Category','NOOR\NN', 'LMS',1,1

The command(s) completed successfully.

sp_droparticle 'LMS' , 'AuthenticateUser'

Server: Msg 14046, Level 16, State 1, Procedure sp_MSdrop_article, Line 65
Could not drop article. A subscription exists on it.

Thanks in advance

Noor

cgross NO[at]SPAM online.microsoft.com
4/2/2004 5:00:59 PM
You probably have another subscription to this article.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
AddThis Social Bookmark Button