Query for Publisher

• Larry C

  Default port

  Points: 1493

  More actions

  July 24, 2003 at 9:56 am

  #83938

  I want to do a query to check to see if the server is a

  replication publisher. I want to do this because I have

  scripts that update schema and of course we add and delete

  columns differently for replicating databases than those

  that are not replicating. I have some servers that are

  replicating and some (for developers) that are not

  replicating.

  Any ideas?

  Thanks!

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 24, 2003 at 5:48 pm

  #466945

  Seems like there should be an easy way. One way would be to check for a row in MSdistpublishers I think.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter