Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    1

    Unanswered: is DB publication/subscription?

    Because of problems trying to alter databases used
    for replication my software would need to find out
    if a database is a publisher or was repliated (using
    T-SQL). Is this possible?

  2. #2
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    Look in BOL for sp_dboption


    This should be able to tell you if the database is Published etc

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •