is_merge_published

• dudik

  SSC Enthusiast

  Points: 196

  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.

  SELECTname as merge_published_db 
  FROMsys.databases 
  WHEREis_merge_published = 1
  ORDER BYmerge_published_db

• Site Owners

  SSC Guru

  Points: 80330

  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.