I am running sql server 2000 sp4. I am trying to do a transactional replication of a large amout of data (40GB). I have created the publication without issue. However when I generate the the subscription, I received the following error:
Could not find stored procedure 'sp_mins_cl_temp_variables_sql'(my_subscribername)(data source); Error 2812
Because the data set is large, I restored the database to the subscriber and select no, the schema and data already exist at the subscriber when I created the push subscription. This generates a no sync initalization for the snapshot. I found that there are certain procedures ( insert, update, and delete) procedures for the publication that do not get generated on the subscriber if you do a non sync initializaiton.
I used sp_scriptpublicationcustomprocs 'publicationname' on the publisher. This generates text for 3 procs that need to be executed on the subscriber. I then executed these procs on the subscriber. It was full of errors.
Any one has another suggestion???
Thanks in advance for your help!!!