Friday, March 23, 2012

Invalid Object Name dbo.sysmergepublications

I have a database which I converted from SQL Server 2000 to SQL Server 2005.
I did this by detaching and attaching. I am trying to set up merge
replication and I am getting the above error. How do I get all the system
tables updated to SQL Server 2005?
I'd run sp_removedbreplication to reset the database before starting.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||What happens when you issue a sp_replicationdboption 'Database Name','merge
publish', true
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:BF324EE5-BC14-4421-9B6C-12DD1B5915A4@.microsoft.com...
>I have a database which I converted from SQL Server 2000 to SQL Server
>2005.
> I did this by detaching and attaching. I am trying to set up merge
> replication and I am getting the above error. How do I get all the system
> tables updated to SQL Server 2005?

No comments:

Post a Comment