Thank you for the pointer. I will check to make sure the db objects referenced in the sprocs are schema qualified.

Thank you very much. That makes sense.

Thank you for posting the script. It is exactly what I am looking for and works beautifully.

Thank you for the reply. I found the cause of the issue. I added the service account to the share and it worked.

It was a user error. Typically if one sets up a publication and subscription under SSMS and not scrutinize the parms, the setup will end up with defaults. ...

Each publication and subscription end up with a snapshot job and a dist job on the distributor box.

This is what is coded to create the snapshot job:

EXEC sp_addpublication_snapshot @publication =...

Thank you everyone for your time and the good comments. They are all valid.

At this writing, I have 2 environments DEV and QA. In QA Replication snapshot...

Thank you for the comments. The deadlocks don't just happen with that one sproc. They happen everywhere on select queries sprocs, on adhoc queries as well. Replication...