Breaking database replication I am trying to break replication between two SQL 2000 databases.  Can this be done while the databases are live? or do they need to be taken offline?
Delete publications from the Local Publications folder in Microsoft SQL Server Management Studio.

To delete a publication



1.Connect to the Publisher in Management Studio, and then expand the server node.

2.Expand the Replication folder, and then expand the Local Publications folder.

3.Right-click the publication you want to delete, and then click Delete.