We need to push all the changes across network to a secondary, reporting
server, on a timely manner. We were using replication in SQL200, but it

There are a lot of new features in SQL 2005. Transactional replication will
place fewer locks on the publisher by default during snapshot generation.

You could also look at database snapshots or log shipping for this.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]