I have completed many projects MS-SQL. Recently, I have been using version 2005, but have also used 2000 and 2008. Specifically, I configured SQL replication across the WAN to replicate transactions in 2 different data centers. This is a native feature of SQL 2005, and I chose to use one-way replication as it was the safest and most reliable.

When possible, I prefer to use log shipping if the enterprise edition of SQL is used.