please can brief how to split the load across multiple servers, using distributed partitions.

thanks

yes it is 4processors and half a million transactions perday.

thanks

The hardware is Dell PowerEdge 6400 using Dell storage and running over 40 databases.

8GB of RAM....

Online transactions half a million.

thanks

We already tried the SQL Replicator but it didn't work under heavy transactions on the 1st SQL Server2k eventhough the 2nd SQL Server2k database is read only.

Even Microsoft is not...