Am I a dinosaur for defaulting to BULK INSERT for tasks like this? I know it is a manual process, including defining the table in the first place, but I...
Yes, it is possible with one publication but in your filter you will need to identify the subscriber to send it the data you intend, e.g. filter on HOST_NAME or...
Thanks for the reply. I saw the transaction log jump in size and I assumed it was because of implementing replication - they say you should never assume!
Thanks for this. I will look into the setup in more detail. As each snapshot is specific to a client it would be ideal to delete it after use - the time involved in...