How to trigger Snapshot and Merge Replication

I have two servers config'd for merge replication (server A is SUB, server B
is PUB)
When insert on server B table1 occur, I need trigger to exec snapshot,
followed by merge replication jobs. The jobs exist on server A.
I know how to create triggers, but not clear on how to trigger a SQL job
from server B to run from server A?
using SQL 2K5
You coyuld set up a linked server and run sp_start_job on server A using a
fully qualified name...
Cheers,
Paul Ibison
sql

How to tell which service pack of SQLCE is installed on the desktop

The title about says it all. For merge replication, I need to make sure the
service packs match up between SQL2000 and SQLCE. How do I tell which SQLCE
version is in?
IIRC check the folder C:\Program Files\Microsoft SQL Server CE
2.0\Redist\Server, the latest one should be there.
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
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||actually this is good up to sp2. After sp 2 you need to check the versions
of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
For sp 4 they are
sscesa20.dll 2.00.7331.0
sscerp20.dll 2.00.7331.0
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
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||Thanks Hilary; that's helpful.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLeiiSD7FHA.1032@.TK2MSFTNGP11.phx.gbl...
> actually this is good up to sp2. After sp 2 you need to check the versions
> of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
> For sp 4 they are
> sscesa20.dll 2.00.7331.0
> sscerp20.dll 2.00.7331.0
> --
> 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
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
>

How to tell what was deleted during synch

Warren,
have a look at my script here:
http://www.replicationanswers.com/Merge.asp
This gives the ability to see pending changes. Once the
merge agent has run, the records have been deleted, so by
then it's too late, unless you want to use LogExplorer.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thanks Paul, much appreciated.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:039301c53503$4d549510$a401280a@.phx.gbl...
> Warren,
> have a look at my script here:
> http://www.replicationanswers.com/Merge.asp
> This gives the ability to see pending changes. Once the
> merge agent has run, the records have been deleted, so by
> then it's too late, unless you want to use LogExplorer.
> HTH,
> Paul Ibison SQL Server MVP,
> www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>