all groups > sql server replication > april 2004 >
You're in the

sql server replication

group:

dynamic filters


Re: dynamic filters Hilary Cotter
4/7/2004 8:16:01 AM
sql server replication:
be careful with user_name(), this resolves to the user kicking off the
agent, which most frequently is your merge agent or distribution agent, and
not the account that the user is logged on with.

[quoted text, click to view]

dynamic filters Noël Thoelen
4/7/2004 10:12:13 AM
Does anybody know what will happen when I use different functions to filter
rows on articles (dynamic filters). In some articles I want to filter using
the HOST_NAME() function, in other rows I want to use the function
USER_NAME()
Is this possible or should this be avoided ?

Re: dynamic filters Noël Thoelen
4/7/2004 11:02:40 AM
Thanks

My statement was not complete. What we need is the in one article we can
filter on host_name, in another article however, we need to filter on
User_name. So, it is not that we want to place to filters on one article.


"Raj Moloye" <rkmoloye@hotmail.com> schreef in bericht
news:OrezH3HHEHA.3832@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]

Re: dynamic filters Raj Moloye
4/7/2004 12:52:43 PM
Noel,
There shouldn't be any problem per se. What I could immediately think of and
suggest is that you look at any relationships that exist among these tables.
These 'might' cause some trouble, where rows in one article that match one
filter may not match with rows in another related table with another filter
(tricky!!, does this make sense?).

Raj

AddThis Social Bookmark Button