"Sylvia" <sylvia@vasilik.com> wrote in message
news:1130803614.051309.52110@g49g2000cwa.googlegroups.com...
> What's the easiest scripted way to completely remove replication?
>
> I've seen this article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;324401
>
> ...but what I'd really like to find is a script that goes on a search
> and destroy mission for replication related stuff (tables, data in
> tables, jobs) and gets rid of it, without having to manually go through
> all this.
>
> The goal is to set up a test server with replication (it will be
> publisher, distributor, and subscriber), and be able to rerun
> replication setup from scripts - the first step being to remove
> replication completely.
>
> thanks for any tips,
> Sylvia
>

"Sylvia" <Puget4753@yahoo.com> wrote in message
news:1131998262.792041.14720@g44g2000cwa.googlegroups.com...
>
> Hilary Cotter wrote:
>> have a look at this
>>
>> http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/71db1f922401f617?dmode=source
>>
>
> Thanks for the reference, Hilary, this looks very useful. I'm assuming
> it's to be run in the Publication database?
>
> One question - I'm confused as to why there's a lot of table create
> statements at the end, instead of just deleting from those tables?
>
> thanks,
> Sylvia
>

Hilary Cotter wrote:
> have a look at this
>
> http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/71db1f922401f617?dmode=source
>