The permissions on the stored procedure should suffice unless the table is in another database. (crossdatabasechaining option)

I've tried your code. The procedure is created by a db_owner in tempdb.

Errors I've...

Chain of ownership gets broken when you use dynamic sql.

Dumping to a textfile?

3th party tools?

A primary key is unique.

Can you give a short table description?

Hello,

Check if the columns involved in the foreignkey are of the same type/size.

Check if 1side is really unique.

It think there is a quite high limit on the number of foreign...

It's normal that performance degrades when running DBCC CHECKDB.

What is your current disklayout?

There is a command to force a checkpoint: CHECKPOINT

CHECKPOINT permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles, and are not...

Indeed weird, creating indexes on that column and selects don't cause problems.

I would drop the table at the subscriber. And see if it gets recreated.

ms page on dropping/adding articles:

http://msdn.microsoft.com/en-us/library/ms152493.aspx

Have to tried in another sequence?

Drop subscription

Drop article

Refresh

Add article

Add subscription?

Worth a try, I'm out of clues.

Perhaps a problem with the insert/update/delete stored procedures?

Have you checked of the replication share is reachable/ not out of space?

Is there some detail info on the error?

Was there a new snapshot since the reactivation?

You will have to find why it is timing out. (bad code, bottlenecks, no indexes, ...)

Execute sp_who2 will show you a list of connections and if they are blocked. Sql...

I haven't much experience with replication. Is it feasible to store the inserts in a seperate table?