Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  replication queries

Author  Topic  swati Starting Member 2 Posts Posted - 2003-04-30 : 01:01:10 Hello, Can anybody help me in giving answers of the following questions - 1.I want to create multiple publications on one table and I would like to know are there limitations on number of publications to be created on one table? 2.Can I pass parameters from the subscriber to the publisher in order to return the dynamic data as per the parameter? like select * from userTable where userid =? ? is the parameter pass to the query for having the user specific data. Shall I have to create the userspecific publications?But this option will increase the number of publications as the user increases.Can I achieve the required functionality by passing the dynamic query to the replication publication?Is it possible? 3.Can I join more than 2 tables in the dynamic filter query using the replication wizard? I am using sql server2000 for creating publications using merge replication and transferring data on sql server ce as a subscriber. The earliest help will be most welcome. Thanks in advance. Regards, Swati