Thank you so much both for the replies. I just wanted to clear the myth that is making the rounds that Load-balancing is possible with SQL Server 2008.
Load-balancing can mean a lot of things, so you could just ask the people that are pushing for it what they actually mean.
It could be that they just don't know what they are talking about, but they may have something specific in mind.
For example, it is possible for multiple servers to share a read-only database by having multiple servers mount the same SAN volume, but this is probably only useful in a limited, data mart application to spread a heavy reporting workload over multiple servers.