N/APosted on - 11/03/2011
My subscription does not feed the latest transactions from the publisher. I tried re-initializing it and saw that the snapshot generates for all the articles, the distribution is completed, and the tables are in sync. But then after just a few days, the subscriber would not receive the most recent data. Now, the distribution agent shows no available transactions, and there are no undistributed commands. There are two subscribers, but only one is claiming to have problems. I have checked the SQL server logs and the ms subscriptions, and there are no space issues or inactive subscriptions. What is wrong with the ms subscription?
Subscription does not feed the latest transactions
Hallo Steve Jenkins,
I guess the reason why your ms subscription does not feed the latest transactions from publisher could be possibly be due to some syntax or semantic errors in the SQL statements that you have used to specify the code for subscription.
Make sure that you have set the operations and constraints properly in the code to allow for the feeds to be published. Check to ensure that they are not any truncation errors in the code, and in case you are using the BULK INSERT statement, you have to be aware that it will not work like the EXECUTE AS LOGIN statement will work because they are meant for two different operations.