"CITS_DBA" <CITSDBA@discussions.microsoft.com> wrote in message
news:5348BE6A-6ED9-452E-9274-FE7F820FAB36@microsoft.com...
> Hi Folks,
>
> Both servers are running SQLServer2005
>
> I have created a publication and now wish to create a push subscription,
> however using the wizard and executing the script that the wizard creates,
> results in the following:
> Via the wizard:
> TITLE: New Subscription Wizard
> ------------------------------
> SQL Server could not create a subscription for Subscriber 'X'.
> -----------------------------
> ADDITIONAL INFORMATION:
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> ------------------------------
> Invalid object name 'sysmergearticles'.
> Could not use view or function 'sysmergeextendedarticlesview' because of
> binding errors.
> The subscription could not be found.
> Changed database context to 'Explore_LEO'. (Microsoft SQL Server, Error:
> 208)
>
> Via the script:
> Msg 208, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 494
> Invalid object name 'sysmergearticles'.
> Msg 4413, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 494
> Could not use view or function 'sysmergeextendedarticlesview' because of
> binding errors.
> Msg 21678, Level 16, State 1, Procedure
> sp_MSrepl_addpushsubscription_agent,
> Line 194
> The parameter "@job_password" can be set to "NULL" only when "@job_login"
> is
> set to "NULL"
>
> Also, where is sp_MSrepl_addsubscription??
>
> Many thanks, in advance,
> Rgds,
> John