load balancing

Hello,

How is load balancing working in SQL Server 2000. We want to have two
different servers as a back end for our web based eCommerce application. Is
this possible? While there be any modification requirement in the applicatio
n?

There's no transparent load balancing in SQL Server. There are options to sp
read load over several
servers, each has advantages and disadvantages. Things you might want to rea
d about in Books Online:

Distributed partitioned views (aka federated servers)
Replication



--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/


"JIM.H." <JIMH@discussions.microsoft.com> wrote in message
news:946586F9-803E-4248-AA8E- 576A144A21FD@microso
ft.com...
> Hello,
>
> How is load balancing working in SQL Server 2000. We want to have two
> different servers as a back end for our web based eCommerce application. I
s
> this possible? While there be any modification requirement in the applicat
ion?
>