I've copied the table structures of a replicated DB from
another SQL Server. I have no need to use replication
with this new DB. When attempting to add a record to any
of the tables, I receive the following error: "Invalid
object name 'dbo.sysmergearticles'". How can I tell the
new DB that there is no need for the merge tables? Or,
how can I get rid of them all together?

Any help or direction is greatly appreciated.

Thanks,
Boyd

In article <378f01c49bfa$e1d37f00$a501280a (AT) phx (DOT) gbl>, Boyd wrote:

This is a strange one.

If you have simply copied the tables over and are trying to simply add
rows to those tables then replication should not come into play.

Is this DB set up for replication?
How are adding the rows?

It looks as though when you are adding the rows to the tables it is
thinking that it has to replicate them so something somewhere thinks it
is involved in replication.

Have a look at

Exec sp_helpreplicationdboption '<db name>'


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

Boyd,
try this:

use databasename
go
sp_removedbreplication databasename
go

HTH,

Paul Ibison (MVP)

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)