I wanted to replicate my database across 2 servers both using sql server 2005. The problem is that the main server have both 'User' and 'Admin' data in a table. At the other end , I want to replicate the entire database but the 'Admin' data should not be replicated.
Is there a way to solve this problem ? Either by configuring the replication or by manual tweaks.
Any help is appreciated.
Thanks