sql server replication: SQL Transactional replication Error-Urgent -- sql server replication

SQL Transactional replication Error-Urgent

Chinnappa Rajesh
9/19/2006 9:58:01 PM

sql server replication:

The distribution agent fails with the following error :

Cannot insert the value NULL into column 'cmdstate', table
'MSreplication_queue'; column does not allow nulls. INSERT fails.
(Source: <ServerName> (Data source); Error number: 515)

{call sp_addqueued_artinfo (1, N'tablename', N'servername', N'database
name', N'REP TRAN Peer Group Tables', N'tablename', N'null', N'conflict_REP
TRAN Peer Group Tables_tablename',

0x0000000000000000000000000000000000000000000000000000000000001eff )}

Here i have mentioned the parameters with sample table,server,database name

The row count for table in subscriber is greater then in publisher. No data
in 'MSreplication_queue'

Anyone suggest what could be the problem
Thanks in advance

Regards,

Re: SQL Transactional replication Error-Urgent

Hilary Cotter
9/20/2006 5:35:35 AM

can you script out your publication and the schema for your problem table
and post them here? Also is this sql 2000 or 2005?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]