SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Replication error-Urgent		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gangadhara.ms
Constraint Violating Yak Guru

India
497 Posts
Posted - 07/29/2012 :  22:10:18  Show Profile  Visit gangadhara.ms's Homepage  Reply with Quote
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

USA
4993 Posts
Posted - 07/29/2012 :  22:33:39  Show Profile  Visit russell's Homepage  Reply with Quote
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.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
4993 Posts
Posted - 07/29/2012 :  22:34:31  Show Profile  Visit russell's Homepage  Reply with Quote
And DO NOT allow write operations at the subscribers. Treat them as read only.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000