Prev: syncobj_* views?
Next: What agent executes sp_adjustpublisheridentityrange?
From: LPR-3rd on 19 Dec 2007 13:16
when I run the script....

EXEC sp_droparticle
@publication = N'CB to 00',
@article = N'CB_PayOuts',
@force_invalidate_snapshot = 1;

I get the error message...

Msg 14046, Level 16, State 1, Procedure sp_droparticle, Line 161
Could not drop article. A subscription exists on it.

So the question is...how do I drop an article, using TSQL w/out
dropping the subscription??

Larry....
From: Hilary Cotter on 19 Dec 2007 22:39
do this

sp_dropsubscription
'publication','articleYouWishToDrop','Subscriber','subscriptionDB'

--
http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames(a)gmail.com> wrote in message
news:cf70f34b-aabc-4e99-b28c-3d72642525e9(a)x69g2000hsx.googlegroups.com...
> when I run the script....
>
> EXEC sp_droparticle
> @publication = N'CB to 00',
> @article = N'CB_PayOuts',
> @force_invalidate_snapshot = 1;
>
> I get the error message...
>
> Msg 14046, Level 16, State 1, Procedure sp_droparticle, Line 161
> Could not drop article. A subscription exists on it.
>
> So the question is...how do I drop an article, using TSQL w/out
> dropping the subscription??
>
> Larry....


From: LPR-3rd on 20 Dec 2007 09:18
Thanks Hilary...have a Merry Christmas
From: Hilary Cotter on 20 Dec 2007 10:11
U2 man! All the best in 2008!

On Dec 20, 9:18 am, LPR-3rd <lrea...(a)gmail.com> wrote:
> Thanks Hilary...have a Merry Christmas

From: PeterCwik on 20 Dec 2007 14:08
On Dec 20, 8:11 am, Hilary Cotter <hilary.cot...(a)gmail.com> wrote:
> U2 man! All the best in 2008!
>
> On Dec 20, 9:18 am, LPR-3rd <lrea...(a)gmail.com> wrote:
>
>
>
> > Thanks Hilary...have a Merry Christmas- Hide quoted text -
>
> - Show quoted text -

Since I only have production replication and not test...This only
drops the article, not whole subscription right?
 |  Next  |  Last
Pages: 1 2
Prev: syncobj_* views?
Next: What agent executes sp_adjustpublisheridentityrange?