Add a record to a replicated table.....

• imran.adam

  Ten Centuries

  Points: 1008

  More actions

  August 21, 2013 at 4:59 am

  #281371

  Hi

  I am quite new to replication but i did my research and have setup transactional replication between two servers and it is has been working well....until now.

  I am trying to add a record to a particular table that is marked for replication on the publisher side and i receive the following error.

  Error message : 'Could not find stored procedure dbo.sp_MSgetreplnick'

  Any ideas on this? Im assuming this is a system SP of some kind and it has something to do with replication

  Any advice would be much appreciated.

  Thanks

• SteveEClarke

  SSCertifiable

  Points: 5161

  More actions

  September 12, 2013 at 5:57 am

  #1649656

  I am assuming that because you think it is a system SP - you have not created any or someone else in your organisation has not created ?

  If you check under database\Programmability - does it show any SP's ?

  ________________________________________________________________________________________________
  Regards
  Steve
  SQL 2008 DBA/DBD - MCTS/MCITP

  Please don't trust me, test the solutions I give you before using them.

• imran.adam

  Ten Centuries

  Points: 1008

  More actions

  September 12, 2013 at 7:52 am

  #1649723

  Thanks for the reply.

  This has now been resolved