Syncronizing on demand -- sql server replication

Anders
8/14/2007 2:38:02 AM

In a merge replication system, are there any command (stored procedure) that
can force a syncronizing, so the user do not need to wait for the scheduled
time for syncronizing?

Anders
8/14/2007 3:26:04 PM

Sorry - I didn't tell that it's SQL server 2000
I can't find a stored procedure with the name sp_start_job

Any hint?

Anders

[quoted text, click to view]

Paul Ibison
8/15/2007 2:36:05 AM

Anders - it's in msdb.
HTH,
Paul Ibison

Anders
8/16/2007 5:56:59 PM

Hi Paul

Thank you - I now found the SP

Thank you for your patience - Now my question is:
- How can I get the Job_id and other needed parameters in this SP?
Are there a table somewhere from where I can retrieve these parameters?

Anders

[quoted text, click to view]

Paul Ibison
8/16/2007 6:22:44 PM

You can use sp_helpmergesubscription or look directly in MSmerge_replinfo.
HTH,
Paul Ibison

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Syncronizing on demand