Killed by sucess. We now have 50 small databases in two way replication connection with a centeral sever. MSSQL 2000. The applicaton is starting to bog down DSL connections are overloaded. Any Tunning hints would be welcome until we can rewrite the app. Currently we have replication once an hour. Thanks Chuck
There are many tips that you will find in this sites http://www.sql-server-performance.com/replication_tuning.asp ---------------------------------------- Cast your vote http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka