"Anders" <Anders@discussions.microsoft.com> wrote in message
news:B72D848D-3C13-4B4C-9CAD-ADE4ECDE151A@microsoft.com...
> Hi Hillay
> Than you for the reply - It worked.
>
> - However, It seems to me that this tool is a "repair tool" for use if I
> accidentally has removed til distribution+publication without first
> removing
> the subscribers. (?)
> But I would like to do it on "the right way" from beginning.
>
> Are there any article that can descibe all the steps to be done from a
> full
> working merge replication back to complete normal DB's (so it's possible
> to
> make alteration in the tables)
>
> (I hesitate to deploy this solution to my customers)
>
> Anders
>
> "Hilary Cotter" wrote:
>
>> run this on the problem database.
>>
>> http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/bcb4193cd889af32?output=gplain
>>
>> --
>> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>>
>> 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
>> "Anders" <Anders@discussions.microsoft.com> wrote in message
>> news:35E0446E-0024-484F-A101-AD60ED626260@microsoft.com...
>> > Hi
>> >
>> > I have now learned how to create a merge replication and manage a
>> > distributor, a publisher and a subscriber. All successful. Great.
>> >
>> > However, I tried it only on a small test database, and now I would like
>> > to
>> > bring back the databases on the 2 servers back to completely normal
>> > situation.
>> > On the distributor: I have disabled the distribution, and consequently,
>> > the
>> > replication monitor disappears, and in the pulisher I see no item, as
>> > expected.
>> > But on the subscriber, in the replication-->subcribers, I still see the
>> > agent, and I cannot delete it. Any attempt to alter the table design
>> > will
>> > fail, it comes with error "-Unable to modify tables since it's used for
>> > merge
>> > replication"
>> >
>> > How can I effectively bring back databases used in a merge replivcation
>> > into
>> > a normal situation.
>> >
>> > Regards
>> > Anders
>>
>>
>>