Unable to access publication properties

• prn9974

  SSCrazy

  Points: 2000

  More actions

  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

• prn9974

  SSCrazy

  Points: 2000

  More actions

  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.

• prn9974

  SSCrazy

  Points: 2000

  More actions

  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