Queued Transaction Failing

Hello,
Can anyone help me with a Queued Transaction thats failing?
I just set this up to do a snapshot and queued
tranactional rep. The snapshot works great the queued part
brings the error (last command)
\\IMYSERVER\Replication\unc\MyDirectory\2004052716 0853
\myfile_0.sql.
I've checked out myfile_0.sql in QA and it works, and the
snapshot deletes and recreates the tables (thats the
script it running).
Thanks for looking
Rose
Rose,
part of your error message is missing - please can you post up the complete
one.
I'm assuming that the missing bit talks about not being able to read the
snapshot file and that this error is produced by the distribution agent. If
this is the case then can you check that the account being used by the
distribution agent (sql server agent) has read rights on the share you're
using.
Regards,
Paul Ibison
|||Thanks for you replay Paul,
Thats all the error message I can get out of it. I have
right clicked on the Subscription, looked in error detail
and that was all that appeared.
I don't think the problem is it can't read it, as I have
some Transactional Reps pointing to the same directory.
Could it be becasue of the table changes the Queued
replication is suppose to make ?

>--Original Message--
>Rose,
>part of your error message is missing - please can you
post up the complete
>one.
>I'm assuming that the missing bit talks about not being
able to read the
>snapshot file and that this error is produced by the
distribution agent. If
>this is the case then can you check that the account
being used by the
>distribution agent (sql server agent) has read rights on
the share you're
>using.
>Regards,
>Paul Ibison
>
>.
>