Hello...
Are the only parameters allowed for dynamic filtering of data just the
Host_Name and SUser_SName?
Just curious...
thanks
- will
Will,
on SQL Server 2000 this is the case. These 2 parameters (suser_sname() and
host_name()) and UDFs using them. Actually the HOSTNAME can be overridden in
the merge job's parameters, so this is not as restrictive as it seems. On
SQL Server 2005 there is the option to override the HOSTNAME setting in the
subscription wizard. Scriptwise this corresponds to
sp_addmergesubscription @.hostname = 'hostname'
and is referred to as the "partition definition".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul..
I am currently overriding the Host_Name value in my application...so that
works fine. I was just hoping/wondering if there could be other parameters
(like a stored proc) that I could pass in... Oh well...guess I'll have to
wait for SQL 2025!
...
"Paul Ibison" wrote:
> Will,
> on SQL Server 2000 this is the case. These 2 parameters (suser_sname() and
> host_name()) and UDFs using them. Actually the HOSTNAME can be overridden in
> the merge job's parameters, so this is not as restrictive as it seems. On
> SQL Server 2005 there is the option to override the HOSTNAME setting in the
> subscription wizard. Scriptwise this corresponds to
> sp_addmergesubscription @.hostname = 'hostname'
> and is referred to as the "partition definition".
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||You could use a UDF to transform the HOSTNAME, or use a join to an
intermediate table to produce a 'many' value filter - it depends on what you
would like to achieve.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||hey...interesting idea about using a UDF. I'll give that some brain power...
thanks!
"Paul Ibison" wrote:
> You could use a UDF to transform the HOSTNAME, or use a join to an
> intermediate table to produce a 'many' value filter - it depends on what you
> would like to achieve.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||HostName and SUSER_SNAME() can both be over ridden. SUSER_SNAME() can be
overridden by PublisherLogin.
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
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23SciuK3JGHA.2628@.TK2MSFTNGP15.phx.gbl...
> Will,
> on SQL Server 2000 this is the case. These 2 parameters (suser_sname() and
> host_name()) and UDFs using them. Actually the HOSTNAME can be overridden
> in the merge job's parameters, so this is not as restrictive as it seems.
> On SQL Server 2005 there is the option to override the HOSTNAME setting in
> the subscription wizard. Scriptwise this corresponds to
> sp_addmergesubscription @.hostname = 'hostname'
> and is referred to as the "partition definition".
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
Tuesday, March 27, 2012
Dynamic Repl....other than Host_Name or SUser_Name ?
Labels:
curious,
database,
dynamic,
filtering,
host_name,
microsoft,
mysql,
oracle,
parameters,
replother,
server,
sql,
suser_name,
suser_snamejust,
thanks-,
thehost_name
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment