many users...all with different data

Just started looking at SQL Server Replication today. Just need to be shoved in the right direction...I have a 1000 users, and each need to have only their personal data replicated to them....So, is this possible, do I create a 1000 "articles" or do I create one article and somehow pass in a parameter?

This can be achieved using one publication with dynamic filtering. Basically you declare a filter like SELECT * FROM MyTable WHERE Somefield = host_name()

Then each time you setup a replica you enter the host_name or use the default which is the name of the computer.

That will filter one table then you can add joins to filter the rest of the database off that one table.

Martin