We would like to restrict the number of records returned
in a LEFT JOIN query but we find that it doesn't work as
it supposed to be.
Query:

I'm looknig to set up a miniature clustering lab at home and looking for some
advice.
I would like to hopefully keep the price tag to around $750-$1250.
I've already found a couple of boxes that I'm going to use for my nodes

I have recently had to rebuild my SQL Server 2000 sp3a 2 node active/passive
cluster running on Windows 2000 AS SP4.  We ran into issues about two weeks
ago after a SAN migration (I'll spare all the gory details).  When my
previous cluster died, I used one of the nodes as a stand ...

SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.
We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
services use.
When I change the password for this account in active directory, I also

I have a setup of SQL Server 2000 Active \ Passive  Cluster on Windows 2003
Environment.  Maintenance plans were created when the Node-1 was active.
Two weeks back the SQL Server cluster service failed over to Node-2, where
in all other services are remain in the Node-1.

I a a two node win 2003 cluster running active / active with serveral SQL
2000 virtual servers between them.  I have noticed the following and am
wondering if this is correct behaviour and if not how I correct it:
1)  If I start up enterprise manager and go to register one of the ...

            I am new to distributed databases. I wanted to use stored
procedures in distributed databases.
If a  view contains query in which tables from different servers are used,
how should I reference them. For example

Anyone here with hands on experience with SQL Clustering and using IPSEC?
Perhaps we could exchange information...
-Arnie Rowland

We're in the process of designing a 2 node sql cluster for a client.  I want
to know the best way to backup/restore the cluster using Veritas Backup Exec
9.1 or 10.0.  I've installed the remote agent to the cluster with no
problem.  I'm using a dedicated management pc that is not ...

Can the Named Pipes protocol be removed from a SQL Cluster
(SQL2000/Win2003)? And it still function properly, of course...
-Arnie Rowland

I've 3 PC. 2 x Win2K AS and 1 Win2K Pro. Is it possible to cluster the 2
Win2K AS as Primary & Secondary while the Win2K Pro serves as the shared disk
server ?
Do I need to get a Raid card for Win2K Pro PC ?

I have a SQL Server cluster running which one database server machine is
active and one database server machine is standby.
But once I tried to test the failover, I have found that both database
server will claim it as active. Which the case is one database server will

I'm new to Legato Networker and am  trying to get a backup of a SQL
server cluster to work on W2K. Have put the -a <virtual server> option
in the job an dthe user I'm connecting with is in al lthe relevent
groups. Agent is installed on the cluster. But all I  get is the

I would like to know the group's experiences on that topic. I had several
issues in the past but antiviruses had changed a lot and maybe you have
good/bad experiences to share that I can apply to a clustered
SQL2000sp3/w2003 install i'm doing now. Hopefully you can include AV ...

After a few frustrating hours yesterday of continually seeing this
error message when trying to install an instance of SQL2000a on to
Windows 2003 cluster I managed to get it to work.  In my case the
answer was simple, on both nodes copy the entire SQL2000a install