sql server replication: Hallo,

I have to set up replication on an sql-server and on serveral clients
(laptops) - (in German) Mergereplikation. Before I do that I need to know
what happens, if the client deletes a row. After the replication I would
expect that row to be deleted on the server database as well. Is that
correct?

Thanks
Susanne

Susanne
this is a wide-ranging question and depends on the 'flavour' of replication you're using. If you have immediate-updating subscribers (snapshot or transactional), 2phase commit is used and the change applies to the publisher and subscriber simultaneously. If you're subscribers are not connected to the publisher, then you have to either use (transactional) queues or merge replication and the delete will propagate to the publisher on synchronisation. For standard snapshot or transactional, the subscribers must be treated as read-only. Merge, as explained above is different in this redard by default, although can be made to be uni-directional using the -EXCHANGETYPE parameter
HTH