Thank you for reviewing my issue. This is my scenario:

- I have one central db (publisher)

- I have 3 other databases (db1, db2, db3) that will have the subscirption that...

Sort of. We have to syncronize Inventory data on 4 seperate servers (located at 4 seperate site but within the same domain) which have the same database.

I need realtime syncronization. All database will be functional at all times. So im guess transactional replication is the more appropriate solution.

I am using SQL 2005 so i have the option of Database mirroring. Do you think that is a valid option in my scenario. Thanks in advance

Yeah. That worked great. Thanks guys....

Hey, that worked well. Thank you very much for your time.....

OK. Found the solution. First remove all sql 2005 utilities that may have been intalled on your computer. Then use the Windows Installer Utility cleaner to remove all MSXML 6.0...

Hey Chris, That worked great. Thanks for all your help.....

No error show up. And yes both databases may have the same primary key in some tables. I dont know what im missing here or just taking the wrong approach....

Yes i am using Transactional Replication using an initial snapshot to create the sync. The issue im having problems with is that i have 2 databases which have the same...