sp_scriptpublicationcustomprocs

• morpheuz

  SSC-Addicted

  Points: 454

  More actions

  December 30, 2003 at 1:08 am

  #83737

  I have created a transactional publication whic does not use the snapshot as the schema and data are already at the subscriber.

  Consequently, I need to use sp_scriptpublicationcustomprocs to generate the INSERT, UDATE and DELETE custom stored procedures for each of teh articles in the publication.

  Trouble is, I cannot find the stored proc anywhere on the publisher. It is referenced in clearly in BOL, including sample syntax, burt I cannot find it anywhere.

  Anybody got any suggestions?

  Regards,

  Morpheuz

  "See how deep the rabbit holes goes..."

  
  "See how deep the rabbit hole goes..."
  

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  December 30, 2003 at 7:16 am

  #488172

  Wich Service Pack??

  You must execute it from the publishing database. What the stored procedure is created in the master db.

  Run

  SELECT * FROM sysobjects WHERE name = 'sp_scriptpublicationcustomprocs' AND xtype = 'P'

  to see if it exists.