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)  more replications

Author  Topic  nejc Starting Member 17 Posts Posted - 2005-08-26 : 07:32:32 I have a few questions (again) :P Is it possible to get more then 1 replication replicate into some certain object. For example: I have tables A, B and C. I have table C on my PC, tables A and B are on each one of my customers' pc. I want to have 2 one-way merge replications - A->C and B->C. Question is.....how do i do that ? And a second question for today... When i generate a script to create a publication, it gives me a script with already predefined constants, articles, subscribers... example: exec sp_replicationdboption @dbname = N'TABLE', @optname = N'merge publish', @value = N'true' GO use [DATABASE] GO Now I am wondering... can i chage where it says dbname = N'TABLE' or use [DATABASE], so there would be a variable, that i'd define using my application ? it should look something like this: use @database_name but it doesnt work. Any ideas ?