Load balancing.

Hi!
I have two sql servers. One raid rack in the middle for them both.
I installe two cluster groups, with two sql installation.
Now I can put a db on one server and it can fail over to the other one and
the other way around. Fine.
But how can I set it up so the same db is located one both cluster groups
(on the raid and shared by both cluster groups) and use some kind of load
balacing system to harvest the power of both servers for one db.
The only ways I have found so far is DTC and replikation. DTC no slack in
time for having the db exactly the same on both servers, but needs knowledge
and rewrite of code to use DTC transactions. Replikation, slack in time in
update between the cluster groups.
Is there another way to do this? We want to use the power of both servers in
a normal situation, have the fail over if one goes down, only one copy of
the db. No slack in time between the both servers.
regards
cj
SQL 2000 Clustering is not capable of load balancing a database.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"Carl-Johan Wik" <cjwik@.hotmail.com> wrote in message
news:%23X%2334HRpFHA.708@.TK2MSFTNGP09.phx.gbl...
> Hi!
> I have two sql servers. One raid rack in the middle for them both.
> I installe two cluster groups, with two sql installation.
> Now I can put a db on one server and it can fail over to the other one and
> the other way around. Fine.
> But how can I set it up so the same db is located one both cluster groups
> (on the raid and shared by both cluster groups) and use some kind of load
> balacing system to harvest the power of both servers for one db.
> The only ways I have found so far is DTC and replikation. DTC no slack in
> time for having the db exactly the same on both servers, but needs
> knowledge and rewrite of code to use DTC transactions. Replikation, slack
> in time in update between the cluster groups.
> Is there another way to do this? We want to use the power of both servers
> in a normal situation, have the fail over if one goes down, only one copy
> of the db. No slack in time between the both servers.
> regards
> cj
>

List of users + roles + rights

How can I generate a list/view of all users/groups with appropriate roles and rigths?SP_HELPROTECT list all the information in the database.|||Hi,
Can someone please let me know if there is some way to find out the roles of a user in SQL server 2000?
The sysusers table has a column called roles that stores a bit set for every role associated with the user. But given a user name / uid how to find out all the roles (role ids will do) associated with that user?
Please help ... its urgent.
Thanks for your time,
Sayali|||In SQL-2000, this is stored in sysmembers (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-m_6f3n.asp).

-PatP

List Box Page Number

Hello,

I have a matrix inside a list box that groups by "question id" to display matrices with summaries for each question. I have checked the box "Insert page break after this list".

I want to be able to place the list box number next to the question, so that I will see something like:

1. Name

2. Category

3. Age

Is there a way to do this? Can I access the current number within the list? If I try the Globals!PageNumber variable, I get an error saying that the variable can only be used in a header or footer.

Thanks,

Michael

Hi,

Are you using any Grouping inside the list? If you are, I believe you can get the number within each list using the following expression:

=RunningValue((<Your List Grouping Field>),CountDistinct,"DataSet1") where "DataSet1" would be the name of your dataset.

If you do not have any grouping for the list, you could try using 'question id' in the expression instead.

Hope it helps.

-Aayush

|||

Aayush,

Thank You! That was exactly what I needed! Worked like a charm!

Michael