Monday, March 19, 2012

Creating a publication

Hi,
I've come across this one before in one of the threads, unfortunately for me the author managed to figure it out for his/her self and there for no answer was posted, so can anybody help PLEASE?

Creating Publication

- Creating Publication 'SQLMobile' (Error)
Messages
* SQL Server could not create publication 'SQLMobile'. (New Publication Wizard)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Invalid object name 'dbo.sysmergepublications'.
Publication 'SQLMobile' does not exist.
Changed database context to 'SQLMobile'. (Microsoft SQL Server, Error: 208)

Its been created via UI

on SQL2005
the distributor is correctly installed

i also have not tried creating a publication on any other database.....this is the first.

Any Ideas?

try this

sp_replicationdboption 'SQLMobile','merge publish','true'

No comments:

Post a Comment