Post reply

Unable to access publication properties

  • March 11, 2008 at 2:46 pm

    #103470

    Hello,

    I am getting the error "Error 208: Invalid Object Name 'MSpub_Identity_range' + sp_articlecolumn " whenever I try to get to the properties of the publication.

    I have searched for this error over the internet and nothing helpful have come up.

    Any ideas?

    Please do help!

    Regards

  • March 11, 2008 at 2:48 pm

    #788276

    Oh! what I missed to add is SQL version..

    Its running on SQL 2000. Publisher/Distributor on the same server and subscriber is a different server.

  • March 12, 2008 at 9:22 am

    #788645

    As a matter on ethics, I am obliged to give this update.

    MSpub_Identity_Range is a replication object created in the publisher database (during creation of replication).

    This was accidentally dropped. I manually recreated this table and now all the issues are resolved.

    Thanks for everyone who took the time to read this.

    Regards

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

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