Re: Joins and dynamic filters with different users
From: Hank (sorry_at_noway.com)
Date: 11/24/04
- Next message: Paul Ibison: "Re: replication user"
- Previous message: Sriram: "Re: Link Table"
- In reply to: Paul Ibison: "Re: Joins and dynamic filters with different users"
- Next in thread: Paul Ibison: "Re: Joins and dynamic filters with different users"
- Reply: Paul Ibison: "Re: Joins and dynamic filters with different users"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 16:26:48 -0600
I've seen several examples in one line code snippets in the sql books where
they do something like this select <columns> from MyTable where
MyTable.LogonUserName = suser_sname()
This is what is leading me to believe that I might be able to match the
suser_sname() with a value that pre-exists in my server database. Does
anyone know of a way to do this?
"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:OchFHFm0EHA.2316@TK2MSFTNGP15.phx.gbl...
> Hank,
> as far as I remember this won't work. The SUSER_SNAME() function returns
the
> login of the sql server agent, which is the application that logs into the
> distributor/publisher. You'd be better off filtering using HOSTNAME and
> running the merge agent activex control with this as a parameter.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
- Next message: Paul Ibison: "Re: replication user"
- Previous message: Sriram: "Re: Link Table"
- In reply to: Paul Ibison: "Re: Joins and dynamic filters with different users"
- Next in thread: Paul Ibison: "Re: Joins and dynamic filters with different users"
- Reply: Paul Ibison: "Re: Joins and dynamic filters with different users"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
