Skip to main content
Database Administrators

Return to Answer

please don't use `code formatting` for emphasis: https://meta.stackexchange.com/q/135112/295232
Source Link
edit approved Apr 18, 2020 at 16:25
Glorfindel
edit approved Apr 18, 2020 at 16:25
Glorfindel
  • 2.2k
  • 5
  • 18
  • 26

I think after adding SPsthe stored procedures, there might be a problem with SPsthem. Maybe they are corrupt,corrupt; in my case they were corrupt as they referred to an articlearticle, that was not in replicated dbthe replicated database. So, my advice it check the SPsstored procedures or add them one by one  (though not the best approach). Whenever I have dealt a situation like yours, I have always assumed, there is something wrong with the published dbpublished database and all of the time it iswas. Resolve the issue and reinitialize and it will do the job, and your regular process will start working.

I think after adding SPs, there might be a problem with SPs. Maybe they are corrupt, in my case they were corrupt as they referred to an article, that was not in replicated db. So, my advice it check the SPs or add them one by one(though not the best approach). Whenever I have dealt a situation like yours, I have always assumed, there is something wrong with the published db and all of the time it is. Resolve the issue and reinitialize and it will do the job, and your regular process will start working.

I think after adding the stored procedures, there might be a problem with them. Maybe they are corrupt; in my case they were corrupt as they referred to an article, that was not in the replicated database. So, my advice it check the stored procedures or add them one by one  (though not the best approach). Whenever I have dealt a situation like yours, I have always assumed, there is something wrong with the published database and all of the time it was. Resolve the issue and reinitialize and it will do the job, and your regular process will start working.

Source Link
M_S_N
M_S_N
  • 111
  • 2

I think after adding SPs, there might be a problem with SPs. Maybe they are corrupt, in my case they were corrupt as they referred to an article, that was not in replicated db. So, my advice it check the SPs or add them one by one(though not the best approach). Whenever I have dealt a situation like yours, I have always assumed, there is something wrong with the published db and all of the time it is. Resolve the issue and reinitialize and it will do the job, and your regular process will start working.