We followed the 33 page instructions about how to configure SQL replication,
but we'd like to undo everything and stop replication. We can't find any
instructions about how to do this. Can anyone tell us where to look??

Thank you!!

I am not sure if there's a step by step guide available for removing
replication. But at a high level, here's what you would do:

- unsubscribe to all publications
- delete publications
- disable publishing and distribution

All of this can be done from Enterprise Manager. Alternatively, from
Enterprise Manager (Tools > Replication > Generate SQL Scripts) you could
generate scripts for removing replication.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

[quoted text, click to view]

Vyas is right. Also, as a shortcut, you can disable publishing/distribution
directly which'll do the other bits behind the scenes. You might be left
with some metadata tables, depending on what scenarion you have set up.
sp_removedbreplication can get rid of some, but some triggers/stored
procs/conflict tables will have to be removed manually. Finally, some table
changes are also not reversed - if you have updatable subscribers or are
using merge replication, the added GUID column will not be removed.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)