Home Forums SQL Server 7,2000 General Linked Server or Replication RE: Linked Server or Replication
Andy Warren
SSC Guru
Points: 119747
More actions
January 9, 2004 at 4:52 am
#489323
I'd always opt for replication over a code solution. If you can keep the data divided so that it only get's written to on one server, that's optimal and you can stick with transactional replication which is simple and dependable.
Andy SQLAndy - My Blog! Connect with me on LinkedIn Follow me on Twitter