Group,
I have a publication with 3 articles that get INSERT/UPDATE/DELETE on =
publisher and DELETE on subscriber. I need the subscriber deletions =
replicated back to publisher so I setup publication that allows =
updatable subscribers then I go thru the subscriber wizard to create a =
push subscription (advanced options in wizard) and on the updatable =
subscriptions set option to "immediate updating - changes are =
immediately applied at Publisher...".

But, when I script out the publication to run later, I notice in the =
part that adds the subscriber...

exec sp_addsubscription=20
....=20
@sync_type =3D N'automatic',=20
@update_mode =3D N'read only',=20
....

that the update mode is read only NOT "sync tran".=20

So this is my first question...
Should it be "sync tran" to accomplish what I've stated above?

Also, when I manually changed to "sync tran" I think the DELETEs at the =
subscriber are trying to replicate back but I get an error (when my app =
at subscriber calls sproc to DELETE) that says "Login failed for user =
'sa'", so it appears as thought the two-phase commit is trying to occur =
but can't due to some authentication problem.

So this is my second question...
Where do I specifiy in my scripts that create publication/subscription, =
the authentication process?

You'll need to enable the advanced options when setting up the =
subscription to have the option of getting an updatable subscriber.
For the login failure, have a look here: =
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;320773
Cheers,