Can't setup replication

Initially, when I started to setup replication I received the error message ~
"one or more articles are published ...", so I issued the following commands
to remove replication settings from the DB:
sp_configure 'allow',1
GO
reconfigure with override
GO
USE ImageCraft
GO
sp_removedbreplication 'IMAGECRAFT'
GO
UPDATE sysobjects set replinfo=0 WHERE replinfo<>0
GO
Drop table MSdynamicsnapshotjobs
Drop table MSdynamicsnapshotviews
Drop table MSmerge_altsyncpartners
Drop table MSmerge_contents
Drop table MSmerge_delete_conflicts
Drop table MSmerge_errorlineage
Drop table MSmerge_genhistory
Drop table MSmerge_replinfo
Drop table MSmerge_tombstone
Drop table MSrepl_identity_range
Drop table sysmergearticles
Drop table sysmergepublications
Drop table sysmergeschemaarticles
Drop table sysmergeschemachange
Drop table sysmergesubscriptions
Drop table sysmergesubsetfilters
GO
sp_configure 'allow',0
GO
reconfigure with override
GO
Appearently, I overkilled it because I get an error message I've never seen
before when adding a table to the replication setup:
SQL Server Enterprise Manager could not initialize an article based on table
'BusinessUnit'.
Error 208: Invalid object name 'sysmergearticles'.
Invalid object name 'sysmergeschemaarticles'.
Invalid object name 'sysmergearticles'.
Invalid object name 'sysmergeschmaarticles'.
Could not use view or function 'sysmergeextendedarticlesview' because of
binding errors.
Could not use view or function 'sysmergeextendedarticlesview' because of
binding errors.
I did a restore on the I am trying to create the replication for, but still
get the same errors.
Any suggestions?
can you disable this database for merge publishing and then try to re-enable
it. Also what version of SQL are you running?
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
"Steven" <Steven@.discussions.microsoft.com> wrote in message
news:1838D345-A23E-4CB6-A122-3736554334BE@.microsoft.com...
> Initially, when I started to setup replication I received the error
> message ~
> "one or more articles are published ...", so I issued the following
> commands
> to remove replication settings from the DB:
> sp_configure 'allow',1
> GO
> reconfigure with override
> GO
> USE ImageCraft
> GO
> sp_removedbreplication 'IMAGECRAFT'
> GO
> UPDATE sysobjects set replinfo=0 WHERE replinfo<>0
> GO
> Drop table MSdynamicsnapshotjobs
> Drop table MSdynamicsnapshotviews
> Drop table MSmerge_altsyncpartners
> Drop table MSmerge_contents
> Drop table MSmerge_delete_conflicts
> Drop table MSmerge_errorlineage
> Drop table MSmerge_genhistory
> Drop table MSmerge_replinfo
> Drop table MSmerge_tombstone
> Drop table MSrepl_identity_range
> Drop table sysmergearticles
> Drop table sysmergepublications
> Drop table sysmergeschemaarticles
> Drop table sysmergeschemachange
> Drop table sysmergesubscriptions
> Drop table sysmergesubsetfilters
> GO
> sp_configure 'allow',0
> GO
> reconfigure with override
> GO
> Appearently, I overkilled it because I get an error message I've never
> seen
> before when adding a table to the replication setup:
> SQL Server Enterprise Manager could not initialize an article based on
> table
> 'BusinessUnit'.
> Error 208: Invalid object name 'sysmergearticles'.
> Invalid object name 'sysmergeschemaarticles'.
> Invalid object name 'sysmergearticles'.
> Invalid object name 'sysmergeschmaarticles'.
> Could not use view or function 'sysmergeextendedarticlesview' because of
> binding errors.
> Could not use view or function 'sysmergeextendedarticlesview' because of
> binding errors.
> I did a restore on the I am trying to create the replication for, but
> still
> get the same errors.
> Any suggestions?
>
|||I tried this, but no success. The system tables required for replication
have been deleted and I'm not sure how to bring them back. This seems to be
crux anyways. Any further thoughts?
"Narayana Vyas Kondreddi" wrote:

> Try this. Using sp_dboption set 'published' and 'merge publish' options to
> false.
> Then from the publisher properties dialog box in enterprise manager, enable
> this database again for replication.
> Then try to setup a publication and see if it works.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Steven" <Steven@.discussions.microsoft.com> wrote in message
> news:1838D345-A23E-4CB6-A122-3736554334BE@.microsoft.com...
>
>
|||I tried this too, but no success. I seem to have deleted the system tables
required for replication and need to bring them back.
"Hilary Cotter" wrote:

> can you disable this database for merge publishing and then try to re-enable
> it. Also what version of SQL are you running?
> --
> 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
> "Steven" <Steven@.discussions.microsoft.com> wrote in message
> news:1838D345-A23E-4CB6-A122-3736554334BE@.microsoft.com...
>
>