23rd April 16:37
SQL Personal Edition
Absolutely. You can use it as a replication subscriber for this.
The restrictions of personal are (source SQL Reskit)
It includes a concurrent workload governor that limits its scalability;
performance degrades when more than five Transact-SQL batches are executed
It can use a maximum of two processors in an SMP computer (only one
processor if running Windows 98 or Windows Millennium Edition).
It cannot act as a transactional replication publisher (subscriber only).
Please note that if the db in question never going to be more than 2Gb (and
graphical interface is not needed) then MSDE2000 would also suffice.
Mark Broadbent mcdba,mcse+i