How can I know the sync status from subcription DB if I have no access to distributer?

Question

Hi there,

 

We are using Push replication in our production environment but have no access to the distributer DB. Can I know the subscription status from subscription DB? For example, complete time, successful or not, etc.

All I searched out from MSDN is I need to query on distributers.

 

Thanks!

Tian

Answer 1

Is it pull or push? In case it is pull then the job is located at the sub

 

---

-- Yaniv www.sqlserverutilities.com http://blogs.microsoft.co.il/blogs/yaniv_etrogi

Answer 2

Push transactional replication, so the job is located at the pub...

Answer 3

Hi Tian,

In case of Push subscriptions, you need access to the distributor for knowing the status of the subscriptions.

HTH,

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com