Post reply

15001 Replication error

  • February 6, 2006 at 9:14 am

    #93253

    I'm trying to create a new publication using Enterprise Manager in SQL Server 2000 but I get error message:

    SQL Server Enterprise Manager could not create publication 'Test' from database 'Reservations'.

    Error 15001: Object 'Test' does not exist or is not a valid object for this operation.

    I tried creating the publication programmatically and got the same error in SP:

    sp_addpublication_snapshot

     

    I can't figure what the problem is. I'm able to create publications for other DBs in the same server.

    Any ideas about what's causing the problem would be greatly appreciated.

    Thansk,

    Mechas

     

     

  • February 6, 2006 at 3:31 pm

    #619120

    Check and see if the Table Test has a Primary Key.

    Kindest Regards,

  • February 7, 2006 at 3:20 am

    #619198

    this error message says it can't find the publication test.

     

    try the following if testdb if your publication database name

     

    sp_replicationdboption 'testdb','publish','true'

    go

    use testdb

    go

    sp_addpublication 'test', @status='active'

    go

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

  • February 7, 2006 at 8:23 am

    #619305

    Thanks Hilary.

    I already did that.

    My script runs:

    sp_replicationdboption

    sp_addpublication

    sp_addpublication_snapshot

     

    This last SP is the one giving me the error.

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply