Getting the host_name value used in dynamic filter when merge succ

I'm trying to find the value that was used when a merge replication suceeded
for an anonymous pull subscribtion. I'm using dynamic filtering with a
modified HOST_NAME value equal to the CustomerID.
I have a stored procedure called by a Replication alert when a merge succeed
on this procedure I need to know what is the HOST_NAME (=CustmoredId) modifed
value that was used. Is this value in one of the MSmerge_ tables or can I
pass it to the stored procedure somehow. Thanks in advance.
You would have to use triggers on some of the tables being replicated to
figure this out. Basically it resolves to the following
1) the host you connect to EM with and ran the merge job. So if your desktop
is called A and you connect to your publisher call B, and started your push
merge agent to subscriber C, the hostname would resolve to A, unless you
over rode the host name using the hostname parameter in your merge agent.
2) If you are using a push subscription and SQL Server agent kicks it off,
the hostname will be your publisher, unless you over rode the host name
using the hostname parameter in your merge agent..
3) If you are using a pull subscription and SQL Server agent kicks it off,
the hostname will be your subscriber, unless you over rode the host name
using the hostname parameter in your merge agent..
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
"Humberto" <Humberto@.discussions.microsoft.com> wrote in message
news:3D3B37BD-4197-46BC-BFE4-09DAE445E2D7@.microsoft.com...
> I'm trying to find the value that was used when a merge replication
suceeded
> for an anonymous pull subscribtion. I'm using dynamic filtering with a
> modified HOST_NAME value equal to the CustomerID.
> I have a stored procedure called by a Replication alert when a merge
succeed
> on this procedure I need to know what is the HOST_NAME (=CustmoredId)
modifed
> value that was used. Is this value in one of the MSmerge_ tables or can I
> pass it to the stored procedure somehow. Thanks in advance.