How to find a Publication is there or Not...

• sundar.srec

  Valued Member

  Points: 51

  More actions

  June 11, 2009 at 3:25 am

  #201263

  Hi,

  I am working with Replication. All are going great. I want to know how we can find out what are the Publication Made and whether a Publication is Present or Not or whether is it Active.

  Suppose I have Published a Publication Named - "MyPublication". I want to know whether that publication is currently present or not,Whether it is Active and details of it.

  If any one of the above is possible in Replication please let me Know how we can do.

  Thanking You...

• hi_abhay78

  SSCertifiable

  Points: 6265

  More actions

  June 11, 2009 at 3:45 am

  #1007860

  1) find out the database acting as publishers :

  use distribution

  go

  select distinct publisher_db from dbo.MSarticles;

  2) use those databases run sp_helppublication to get the details .

  3) you can also use replication monitor (right click replication and select launch replication monitor )

  Abhay Chaudhary
  Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)