Hi all,
I have set up Replication in a test environment replicating from 2005 to 2012 and have got it working using the following set up:
Server 1 - Distributor and Publisher
Server 2 - Subscription
This is set up as snapshot replication as only need to take a copy once a day.
I want to set up the validation but there is no option on the menu, I've tried both servers.
I also tried to run the sp_publication_validation stored proc as a test but it says my publication does not exist.
It could be something straight forward as permissions or SQL version but I haven't been able to locate any info online. Ideally I would like to use the menu option.
Any help much appreciated!