To start a snapshot agent i am using
sp_startpublication_snapshot @publication = 'PublicationName'
Similarly how i can start synchronization in merge replication?
now i am right clicking on subscriber and clicking on view synchronization status and then clicking on start.So i want to run the same by using script.
- Edited by IT researcher Wednesday, November 21, 2012 11:46 AM
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
what are the parameters for sp_startmergepushsubscription_agent?
I dint get much information about sp_startmergepushsubscription_agent in websites.Is this syntax proper?
sp_startmergepushsubscription_agent @publication = 'Publication name', @subscriber='instancename', @subscriber_db='databsename'
- Edited by IT researcher Thursday, November 22, 2012 4:53 AM