Replication and multipule subscriptions

[jeffmoore64]

Hi,
Can I do this:
I need to add a second subscription to a database that already has a subscription. The second sub will replicate 3 new tables to my db. I keep getting the error when I do this "Subscription already exsists"
I really don't want to have to drop my existing sub and recreate it.
Am I missing a concept here?
TIA

 

[mrdenny]

You should be able to setup two subscriptions from a single publisher to a single subscriber.

The publications and subscriptions will need to both have different names.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com