DPV's

Is there any other way to do load-balancing other than SQL Server 2000's
Distributed partition Views? I am aware that 2005 has done something like
Distributed Tables, but that is, for my purposes, the same thing.
What I do not want to do is try to guess what gets accessed in what fashion
and try and place tables on various nodes of the cluster.\
Thanks,
jay2005's table partitioning cannot be distributed across servers. DPVs are
still the way to do that in 2005.
By the way, this isn't really "load balancing"--it's more along the lines of
scale out. For more traditional load balancing you might take a look at SQL
Server 2005's peer-to-peer replication technology (although I've heard very
mixed reviews on its effectiveness).
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Jay" <nospam@.nospam.org> wrote in message
news:OtIO7jo6HHA.5316@.TK2MSFTNGP04.phx.gbl...
> Is there any other way to do load-balancing other than SQL Server 2000's
> Distributed partition Views? I am aware that 2005 has done something like
> Distributed Tables, but that is, for my purposes, the same thing.
> What I do not want to do is try to guess what gets accessed in what
> fashion and try and place tables on various nodes of the cluster.\
> Thanks,
> jay
>

doing transactions with linked server(ole db provider)

Hi all,

When i begin a distributed transaction..., do i need to always
set xact_abort on?

But when i tried to put custom error handling to roll back a transaction with a linked server , it seems its impossible (as set xact_abort on, already automatically rolls back the transaction)

Does anyone have any ideas on this?

Thanks in advance

Bennyset xact_abort on is not required for distributed transactions.|||But i get an error when i dont set that.
Do you know what has to be done instead?

Thanks for your feedback

Benny