hidme


Hi all,

I try to remove a replication with from my MS SQL 2000

DECLARE @publication AS sysname
DECLARE @publicationDB AS sysname
SET @publication = N'MyDB_merge'
SET @publicationDB = N'MyDB'

-- Remove the merge publication.
USE [MyDB]
EXEC sp_dropmergepublication @publication = @publication;

-- Remove replication objects from the database.
USE master
EXEC sp_replicationdboption
@dbname = @publicationDB,
@optname = N'merge publish',
@value = N'false'
GO

but seems to do nothing, how many time cost this operation

MSSQL search something

There is a solution for remove rapidly a replication from my database.

Thank's a lot bye

Bye

Hid




Re: Remove replication

Hilary Cotter


This should work.

I would drop all subscriptions before dropping the publication. Why do you think this is not working






Re: Remove replication

hidme

thank's for reply,

well, how can I remove all subscription, in less time possible.

I must reorganize myDB and replication in out of work but I don't kwon how destroy it.

Bye by Hid!