You can't load balance two or more SQL Servers without huge amounts of work to keep the two databases in sync eg though (peer-to-peer replication).
Typically you'd load balance a group of web servers and they'd all talk to a single SQL Server, probably a more powerful server.
That said, peer-to-peer replication is a SQL 2005+ feature, I assume you have SQL 2000 since you posted in the SQL 2000 forums. If that's the case, the best advice I can give is upgrade to something less than 10 years old.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass