Procedure or function sp_MSreplraiserror has too many arguments specified.

UPDATE (27/02/2018)


            IF @@rowcount = 0 
              IF @@microsoftversion > 0x07320000 
                    IF EXISTS (SELECT * 
                               FROM   sys.all_parameters 
                               WHERE  object_id = Object_id('sp_MSreplraiserror' 
                                      AND [name] = '@param3') 
                          SET @primarykey_text = 
                          @primarykey_text + '[TableD_ID] = ' 

                          EXEC Sp_msreplraiserror 
                      EXEC Sp_msreplraiserror 









sp_scriptpublicationcustomprocs @publication = ”




4 Replies to “Procedure or function sp_MSreplraiserror has too many arguments specified.”

  1. MS have given us a way to create our own replication procedures for a long time already. Have a look at Using the dbo.sp_register_custom_scripting procedure you can include your own custom code generator into the transactional replication engine and generate procedures that do not contain the error. We use this method to generate custom procedures as a part of our archiving system: one of our replication subscribers ignores delete statements under specific circumstances making that this subscriber contains all current plus all historic data, all other subscribers do execute the delete statements in their copies and thus contain only the current data.


Leave a Reply


You are commenting using your account. Log Out /  Change )

Google photo


Twitter picture


Facebook photo


Connecting to %s
