is_merge_published

• dudik

  SSC Enthusiast

  Points: 133

  More actions

  December 1, 2020 at 3:34 pm

  #3815608

  I'm running the following query to get a list of my Merge Publications but I'm getting results of publications I have deleted a long time ago.

  Thanks in advance,

  David.

  SELECT		name as merge_published_db 
  FROM		sys.databases 
  WHERE		is_merge_published = 1
  ORDER BY	merge_published_db

• Site Owners

  SSC Guru

  Points: 80372

  More actions

  December 2, 2020 at 4:10 pm

  #3816090

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.