invalid update statement for article ...

Last Post 13 Mar 2008 11:43 PM by SQLUSA. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
trans53
New Member
New Member

--
13 Mar 2008 07:00 PM
Hi guys, today our log agent failed with "invalid update statement for article..." error. What can be a problem in this case and what is the best way to fix? Basically we had to drop and recreate publication and resynchronize. it tool a long time and i am wondering if there are a better way to do it.

Also, it's possible to find the actual update statement that cause the problem from the system tables?

Thanks
SQLUSA
New Member
New Member

--
13 Mar 2008 11:43 PM
Perhaps it was trying to update when the article did not exist?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/ SQL Server DBA Training
trans53
New Member
New Member

--
14 Mar 2008 07:28 AM
Thanks, i checked this table but no commands exists for this article, it's probably been purged.
trans53
New Member
New Member

--
14 Mar 2008 05:54 PM
good point, never thought about that.


Acceptable Use Policy
---