[thelist] SQL Server and partial replication

[john at evolt.org.uk]

Hi

Am investigating a question for a friend, and here it is:

Is it possible to keep a second copy of only part of a Microsoft SQL
Server database, either in a second SQL Server or MS Access via ODBC,
*and* have the master DB feed updates to the 'slave' live or near-live?

Failing that, any ideas on how to get something close using string and
sellotape will do for now :-)

Cheers in advance

jh