I have replication configured on a SQL 2008 Database. The tables involved are something like this;
FK_Product_Image FOREIGN KEY(ImageID) REFERENCES tbl.Image (ImageID)
tbl.Product is part of a Transactional publication with updatable subscriptions.
tbl.Image is part of a Merge publication
I have no problem creating/modifying products with an image on the publisher, doing it on the subscriber will replicate the Image but won't replicate the product on Modify/create.
The stored procedure that does the create/modification of the Product will insert the Image into tbl.Image then create/update the product with the ID returned from inserting the image.
Can anyone tell me why the transactional bit doesn't work when its done on the subscriber?
Replication monitor doesnt give me any errors or warning and there are no errors in any event log's.
Any help appreciated