Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication Error

Author  Topic 

hohoho
Starting Member

2 Posts

Posted - 2008-11-09 : 21:50:04
Hi,

I got a replication error "Procedure or function sp_MSins_Members has too many arguments specified."

The original publication is working fine. After I add the Members table into this publication, it threw this error.

I have double checked all the parameters of the table and SP and they are same and correct. And the publication SQL server and subscription SQL server is SQL 2000 server with SP4.

I don't know what's going on...could you please give me some advice?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-09 : 22:48:04
I get that error every now and then. I'm sure it's a bug. The way we fix it is by rebuilding replication.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

hohoho
Starting Member

2 Posts

Posted - 2008-11-10 : 00:18:44
Thanks for your quick reply. Actually, I have tried to rebuild the replication few times but I still got the same error. Do you think it should be related to there is a Timestamp data type column inside the sp_MSins_Members?
Go to Top of Page
   

- Advertisement -