How to encrypt communication between servers when merge

I want to know how to obtain an encrypted communication
between two SQL Servers using Replication.
I saw that using SSL is posible to grant secure
communication between client an server, but how can i
encrypt communication between two servers?
Hector,
as far as I understand, The SSL encryption applies to all inter-computer communication protocols supported by SQL Server 2000. Alternatively you can use Multi-protocol with encryption facility, for more information review books online.
Regards,
Paul Ibison

How to drop merge replication system tables

Hi, we have a database wich used merge replication.
We disabled merge on this db, but '%onflict%' system tables persists,
leading to error when trying to drop them.
How can I drop those tables?
TIA,
Roberto Souza.
You could use sp_subscription_cleanup
There's a fairly good list of sp's used in replication at this site:
http://doc.ddart.net/mssql/sql70/sp_00.htm
"Roberto Souza" wrote:

> Hi, we have a database wich used merge replication.
> We disabled merge on this db, but '%onflict%' system tables persists,
> leading to error when trying to drop them.
> How can I drop those tables?
> TIA,
> Roberto Souza.
>
>
|||AFAIR this won't remove them. You should be able to use
drop table and the tablename from Query Analyser though.
Rgds,
Paul Ibison