Hi,

My main question is whether the operation is atomic or not. For
snapshot replication in sql server, how does the subscription server
apply the table change - is it a drop/create, or a truncate/bcp? And is
it wrapped in a transaction.

Replication is happening roughly every minute (for a small table, but
all rows change so I am using snapshot instead of transaction) and I
once received a "object does not exist" when I was running a stored
procedure. It only happened once, but it made me wonder whether I
happened to catch the table when it was in an inconsistent state.

Thanks!

-Stantale