What does the conflict viewer reveal? This should contain a record of why the insert was rolled back.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ...

sounds like you are using immediate updating. Consider using bi-directional transaction, queued updating, or immeidate with queued failover and manually fail to queued, or merge replication.

My aren't we being snide Vinny or is it Mark?

I strongly suggest you review the posts in groups.google.com for 14294 , ie

http://groups.google.com/group/microsoft.public.sqlserver.replication/search?group=microsoft.public.sqlserver.replication&q=14294+&qt_g=1&searchnow=Search+this+group

Microsoft PSS support engineers have responded with some...

Download the code samples in my sig. There are examles of how to do it there.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing...

use sp_addsubscription and in the @article parameter use the article name.

--

Hilary Cotter

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

You should be able to package both scripts up in the post snapshot command.

you can also deploy them through sp_addscriptexec

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for...

Regretably this is a design flaw and you have to manually edit the update proc to remove the identity column update.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking...

The reason might be logged in the conflict viewer.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

do a no-sync subscription or use the keep table unchanged option.

If you want new deletes (deletes that occur on your publisher after the snapshot is applied) to only occur on...

The agent does not have enough time to run. Set QueryTimeOut to a larger value.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

right click on the agent, select agent properties, and make the job owner sa.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

enable logging to determine exactly what the problem is. Many times this error is solved by rerunning the merge agent, or by setting querytimeout to a larger value.

Consult this kb...

can you post the schema for the problem table? Script it and related tables out along with pk's and fk's on the publisher and subscriber.

--

Hilary Cotter

Looking for a SQL...

It is possible.

It is likely you have run into another problem - please refer to this link for more info.

http://www.indexserverfaq.com/tablenotenabled.htm

--

Hilary Cotter

Looking for a SQL Server replication book?

You will likely find other missing stored procedures as well. It sounds like your latest sp did not apply correctly. You will need to reapply it and all subsequent hot...