Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Can't use replication stored procedures

Author  Topic  MuadDBA 628 Posts Posted - 2008-02-13 : 15:41:53 I can't seem to win for losing with one of my servers. I use the GUI to install replication (tools, replication, configure pulishing etc) and add a publication, but when I want to stop replicating that database, I run into problems. I use sp_removedbreplication, but it tells me that transactional replication stored procedures are not installed, run sp_replicationoption to install them. (yes, I configured the server to do transactional replication) So, I run sp_replicationoption to instal the transactional storedprocs, and it tells me there was an error, to look at the replcom.out file to see it. I looked through that fle and the other files generated by the proc and see no error other than some "cannot add row to sysdepends" errors. No indication at all for what could have gone wrong. Can someone help me figure it out?