• 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?



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

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

  • Wich Service Pack??

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


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

    to see if it exists.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply