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.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2012-07-29 : 22:10:18
|
| Hi All.We have issue with transactional replication,it used to work correctly sometimes but sometimes not.Below is the error message,please help us to resolve this.Command attempted:if @@trancount > 0 rollback tran(Transaction sequence number: 0x001F4B00000077AB00A400000000, Command ID: 1)Error messages:Procedure or function sp_MSupd_dboEmployee has too many arguments specified. (Source: MSSQLServer, Error number: 8144)Get help: http://help/8144 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-07-29 : 22:33:39
|
| Seems likely you've turned off replicating schema changes and dropped a column (or columns).Review the code of the stored procedure. There should be a param for each column and no more.You can manually modify the proc if you want. It's already broken, can't make it worse.Running the snapshot agent ought to cllear things up. If not, drop and recreate the publication and subscription(s).Make sure that schema changes are replicated. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-07-29 : 22:34:31
|
| And DO NOT allow write operations at the subscribers. Treat them as read only. |
|
|
|
|
|
|
Replication error-Urgent