find if a sql 2005 server has already been used for replication RRS feed

  • Question

  • I have this requirement where i am using replication of data base. I am enabling data replication on a data base using sql scripts. But the problem is if the database server has already been used as a publisher the sql script will not run saying that there the sql server is already being used for distribution. Is there any way in which i can find out whether replication is enabled on the database server  programmatically using c#  before i can run the script.

    Any help will be greatly appreciated.

    H Kiran Krishna.
    Wednesday, July 4, 2007 5:24 AM