Running 2005. I figured with the "Replicate schema changes" set to true
it would have dropped the view as well.

But tables are dropping fine. Just not this stinkin view.





-----Original Message-----
From: Stephen Dyckes
[mailto:mssqldba-ezmlmshield-x81488192.[Email address protected]
Sent: Thursday, November 29, 2007 3:33 PM
To: LazyDBA Discussion
Subject: RE: Dropping items from replication

Are you on 2000? Or 2005? As I recall on 2000 I have had to recreate the
snapshot, but on 2005 I have been able to drop a table. I have not tried
a view, but think it would be the same.

Stephen

-----Original Message-----
From: Jonathan Baker
[mailto:mssqldba-ezmlmshield-x36400610.[Email address protected]
Sent: Thursday, November 29, 2007 3:15 PM
To: LazyDBA Discussion
Subject: Dropping items from replication

I am attempting to drop a couple of views that are published articles
for transaction replication.



I would like to do this without having to drop the subscription first
(sp_droparticle won't allow). Anyone know of a work around for this?
Rebuilding the snapshot to recreate my subscription could take quite
awhile.





Jon



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-----------------------------------------
The information contained in this e-mail message is intended only
for the personal and confidential use of the recipient(s) named
above. This message may be an attorney-client communication and/or
work product and as such is privileged and confidential. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are
hereby notified that you have received this document in error and
that any review, dissemination, distribution, or copying of this
message is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail, and
delete the original message.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page