October 6, 2003 at 6:44 pm
When I set up Publication for Snapshot, I can "tick" to publish all "Tables". However, if I go for Transactional (with the same database), I can not "tick" to publish all "Tables". I dont understand why. Please note that I can publish "store procedures" though. Because I really need the Transactional replication so any help would be greatly appreciated.
Thanks again.
October 7, 2003 at 4:20 am
Usually because they don't have a primary key - a requirement for transactional. Note that selecting stored procedures means that they get pushed over with the initial snapshot, but subsequent proc changes on the publisher are NOT pushed to the subscriber.
Andy
October 7, 2003 at 7:18 pm
You are correct Andy. The dude set up the database did not create Primary Key for the table. I created it and it went pass that stage. Thank you for your information.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply