Keep in mind this is the first of a much more complexe resolver

CREATE PROC AnaResolver

@tableownersysname, -- this is the publisher owner, but we assume its always dbo at subscriber.

@tablenamesysname, --...

I've found a workaround using a mixture of different sugestions.

first set the context_info of the session

declare @BinarySessionId varbinary(128)

select @BinarySessionId = convert(varbinary(128), @@spid)

Set context_info @sessionid

Then add in the Trigger :

Declare @BinarySessionIdToSkip...

thk Andy

your solution worked perfectly (detach/reattach)

Alain

there's 2 jobs in a snapshot replication

1- snapshot agent (which makes the snapshot files) (5min)

2- distribution agent (applies the snapshot files) (30 sec)

the main reason we don't want to reinit...