Sql query to find Publisher name from a subscriber

• jain_abhishek

  Mr or Mrs. 500

  Points: 535

  More actions

  June 12, 2009 at 2:23 am

  #95423

  I have One Subscriber and more then one Publisher for this subscriber .These subscriber and publishers are on different different servers (machines) i.e. if one subscriber and 2 publisher then there will be 3 server.Now I want to run a sql query on the Subscriber and want to know the names of Publishers server .

  Please tell me query

• ps.

  One Orange Chip

  Points: 29423

  More actions

  June 13, 2009 at 9:42 am

  #1009089

  you can query MSsubscription_properties table on the subscriber (pull subscriptions) and at distribution db for push subscribtions.

  refer

  http://msdn.microsoft.com/en-us/library/ms190291(SQL.90).aspx

  ---

  
  Pradeep Singh