Error while creating Publication on sql server 2005

• neellotus07

  Ten Centuries

  Points: 1245

  More actions

  March 9, 2013 at 3:48 am

  #290853

  Hi all,

  i am re-creating new publication through New Publication Wizard but it showing Error :- "sp_MSreplagentjobexists can only be executed in the 'distribution' database.Object 'PUM_NM' does not exist or is not a valid object for this operation."

  Re-creating because i deleted Replication in following manner:-

  - Delete the subscriptions

  - Delete the publications

  after this i run following commands:-

  alter database distribution set offline;

  drop database distribution;

  Then i realize alter & drop distribution db is very wrong so i re-attached distribution db on both server through SSMS then run following commands to remove replications:-

  exec sp_removedbreplication @dbname='distribution'

  exec sp_removedbreplication @dbname="STBData" (STBData :- from which articles to be publish).

  Now i am creating again Publication on "STBData" Server but it is displaying above error.

  i also tried Disable Publishing but it is showing error "Invalid object name 'dbo.syssubscriptons'

  Pls help me how i can re-create publications,subscriptions & replication.

  i will be very thankful to you.

  Thanx

• neellotus07

  Ten Centuries

  Points: 1245

  More actions

  March 11, 2013 at 12:36 am

  #1595401

  it is surprised for me that no one know solution of this problem.

  Neel