SQL Server Performance

Cant see any data in many tables

Discussion in 'SQL Server 2005 Replication' started by DaddyYankee, Oct 16, 2007.

  1. DaddyYankee New Member

    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
  2. satya Moderator

    Any error or warning on replication monitor?
  3. thomas New Member

    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?

Share This Page