SQL Server 2000 dynamic filters by SUSER_SNAME() -- sql server replication

Ming Yeung
12/20/2006 10:47:00 PM

Am I doing this right

Create Publication with dynamic filters ie. select * from employee where
employeelogin = SUSER_NAME()

1. Create Snap Shot
2. Create Dynamic Snap shot with SUSER_NAME() parmater filled in ie
SUSERNAME() = mydomain\myuser
3. Pick a new folder for dynamic snap shot ->New Folder Called myUser

Create PULL Subscription
- This is where things get foggy
In order to get this work for a SQL 2K to SQL 2K when I created subscription
i pointed my path as the myUser Folder it then gets the right info for me.

Am I doing this right?

And how can i get this to work with SQL Mobile? I really need help with
this...

Hilary Cotter
12/21/2006 12:00:00 AM

This is exactly how you do it. Make sure that your publisher login is your
mydomain\myuser account as well.

I think your problem probably is in your code. Try first to get it working
to a SQL Server 2005 machine and then try to implement it in code.

--
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

[quoted text, click to view]

sql server replication : SQL Server 2000 dynamic filters by SUSER_SNAME()