[quoted text, click to view]

SQL Server does not do load balancing automatically.

You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.

Check out Partitioned Data in the BOL.

HTH

Rick Sawtell
MCT, MCSD, MCDBA

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila