SQL 2000 / 2005 Replication 수동 삭제 방법

Replication 의 수동 삭제는 다음의 순서에 따라 이루어 져야 한다.
구독자 > 게시자 > 배포자

[게시자 삭제 방법]

스냅샷 게시자 삭제 (sp_droppublication)
You can use the sp_droppublication system stored procedure to drop a publication and the articles that are associated with the publication. You must run the stored procedure at Publisher on the publication database.
- 예
USE <Publication database name>
GO
EXEC sp_droppublication @publication = N'<Publication name>'
USE master
GO
exec sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'

트렌젝션 로그 게시자 삭제 (sp_dropmergepublication)
You can use the sp_dropmergepublication system stored procedure to drop a merge publication and the Snapshot Agent that is associated with the merge publication. The articles that are associated with the publication are also dropped. You must run the stored procedure at Publisher on the publication database.
- 예
USE <Publication database name>
GO
EXEC sp_droppublication @publication = N'<Publication name>'
USE master
GO
EXEC sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'

머지 게시자 삭제 (sp_replicationdboption)
You can use the sp_replicationdboption system stored procedure to set a replication database option for the current database. You must run the stored procedure at the Publisher server.
- 예
USE <Publication database name>
GO
EXEC sp_dropmergepublication @publication = N'<Publication name>'
USE master
GO
EXEC sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'merge publish', @value = N'false'

구독자 / 배포자 삭제 는 다음 문서를 참고한다.
http://support.microsoft.com/kb/324401