How I can do live replication of few tables in SQL Server?

The reason why I would like to achieve this is so that I can run SQL Statements on those tables without worrying about the table being locked

  • Have you read up on transactional replication? – Nic Nov 15 '16 at 14:35
  • Nope, but certainly going to do so now. Thanks Nic – user2040021 Nov 15 '16 at 14:42

I would suggest start at


This link gives detailed steps for implementing replication


Not the answer you're looking for?Browse other questions tagged or ask your own question.