Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    1

    Unanswered: Replication Help needed ASAP

    SQL Server 2000

    Ran sp_removedbreplication @dbname = 'FooDatabase'
    Did NOT want to do that!
    Have the replication scripted out
    but getting errors when trying to run the script to recreate.
    All Push

    I tried
    sp_droppublication 'Foopubname'
    sp_MSload_replication_status

    Error 21776: [SQL-DMO] the 'publication name' was not found in the
    TransPublications collection. I cannot create a new publication of the same
    name.

  2. #2
    Join Date
    Jul 2005
    Location
    New Zealand
    Posts
    61
    What exactly is it that you are trying to do? Recreate a publication, subscribe to a Publication or both?

Posting Permissions

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