Hi Folks, We have a transaction replication setup for all tables.The snapshot and distribution jobs are fine. But I cant see any data on the destination database.This is strange.For last 2 days we can see any data on destination server. I reinitialsise subscription job it executed smoothly but still I cant see any data. Wondering what went wrong..Any comments
Have you got full permissions in the subscribed database? Is replication using Windows Security? Are you sure the tables haven't been accidentally created (by the snapshot) in another schema or in a user's ownership other than dbo? Are there are restriction clauses or filters on the publications that may have excluded all current data, unintentionally?