I am using SQL Server 2008 Express. I created a new DB and then used Distrib.exe to create and populate the tables. It worked fine. However then I deleted one of the tables and ran the command again from command prompt. It did not pick up the table
that I had dropped. I did not get any error messages but just a message saying, No replicated transactions are available. I checked the snapshot. The table I dropped is in the Snapshot. I am using a transactional Publication and Pull Subscription.
Any ideas why the the deleted table is being missed by Distrib??
Any help will be much appreciated.
View Complete Post