SQL Server 2005 Mirror table between databases on same server

view full story

http://serverfault.com – I've been using transactional replication to mirror a table from one database to another and lately it's been a pain to keep running. My goal is to simply keep an exact copy of a table in another database. Table inserts are about 100 a day from the ASP page from which records submitted, up to a maximum of 400 per day on peak days. The total records in the table wind up to be about 20,000 by the end of a period, when we flush the table. The table has a few text fields, but isn't huge. What's the easiest way to write inserted rows and updates to those rows to another database table on the s (HowTos)