Thanks for the extra info Steve. I will setup the transactional replication in my test lab next week and test how it all works.

Guys, thanks for your replies.

I'll have a readup on transactional replication