May 15, 2012 at 4:56 am
Hi Guys,
Wonder if you could help me.
To provide scenario, we want to replicate tables from our OLTP server to a reporting server so that internal users are able to query data safely.
We have 2 databases which we want to replicate tables from, so DB1 and DB2 both on OLTP server (distribution database also on OLTP for now).
All tables then go to our subscriber database on reporting server.
This seemed to work fine until I have come across a problem when I wanted to replicate a table named ‘service’ on DB1 and another table also called ‘service’ on DB2 (going to same subscriber database).
When I do this I then get an error message:
Procedure or function sp_MSupd_dboService has too many arguments specified. (Source: MSSQLServer, Error number: 8144)
To try get round this I renamed the destination object by changing the ‘destination object name’ in article properties so that the ‘service’ table replicates to the table DB2_Service in the subscriber database.
I then reinitialised creating new snapshot.
However when I do this, I still get the same error message.
For now, I have removed the ‘service’ table from the publication on DB1 and everything is OK again. However, would someone be able to advise where I am going wrong here? I’m assuming there is something else I need to do to get round this problem.
So you know both servers are SQL 2005.
OLTP:9.00.4266.00SP3Standard Edition (64-bit) (Long overdue for service pack I know)
Reporting:9.00.5000.00SP4Enterprise Edition (64-bit)
Any advice would be greatly appreciated.
Cheers,
Sam
May 15, 2012 at 6:36 am
Typical that shortly after I post this I find answer.
You also have to update the INSERT, UPDATE, DELETE stored procedures to get this to work (in statement delivery section on article details). Once I changed SP's to have slightly different names and reinitialised, it worked.
Sorry to waste anyones time!
Cheers,
Sam
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply