May 31, 2007 at 1:26 pm
The publisher is on sql2K and subscriber is on sql2k5. The distribution agent failed with the following error.
Procedure or function sp_MSins_sub_category has too many arguments specified. As we can see from the error that its a procedure with too many parameters. When i check on publisher it has 10 parameters while at subscriber it has 12 parameters. So If i try to generate script create or alter for that procedure it throws the error as
'script failed for storedprocedure 'dbo.sp_msins_sub_category'. (microsoft.sqlserver.Smo).
Additional Information: Syntax error in Text Header NumberedStoredProcedure 'sp_Msins_sub_category;2.(microsoft.sqlserver.Smo)
How can i modify the procedure and get replication up. Thanks in advance.
May 26, 2009 at 10:22 pm
I have the same problem. Did you ever find an answer?
June 9, 2009 at 10:55 am
On the Publisher, try running the stored proc sp_scriptpublicationcustomprocs with the article name, it will generate the stored procs on the Output of the query analyzer window (Make sure you set the Max result to be shown in the output as the maximum allowed), create these Sprocs in the Subscriber.
Just out of curiosity, did you by any chance alter the table in Publisher and then did not resnapshot the table?
-Roy
October 8, 2010 at 5:00 am
Remove any comments before the CREATE PROC / ALTER PROC stmt of the SP. It will then work.
It is a bug in MS SQL (SMO issue) and will be resolved in some later releases
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply