I am attempting to configure SIS in a clustered environment using the
instructions found at http://msdn2.microsoft.com/en-us/library/ms345193.aspx.
I have added the required dependancies to a new generic resource in
the Cluster Adminstration screen and it is now asking me for DHCP

Is it possible to have a stretched cluster (MNS) across 2 datacenters running
SQL?
For example, a SAN in each datacenter with replication, and 1 node located
in each site.

I am sure that someone has managed to do this. We have a 64_bit Clustered
SQL2005 SP2 build 3175 server that we created as Latin1_General_Bin. We want
to change it to the North American default but keep getting errors. The
latest was: - SQL Server Setup is unable to run on this ...

I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I have three NIC's in each server.
Each NIC is connected to a different network:
192.168.100.1 is the public NIC
10.0.0.1 is the NIC used for communication betwen the cluster nodes (heartbeat)

How to genericaly search the entire db for any text string in any stored
procedure, function, table definition, agent job, etc. Any one command or
anyone have a stored proc that does this wide search?

I have two node cluster (active-pasive) and two instances of SQL server 2005
running on that cluster. Default SQL instance was installed as clustered, the
second named instance was not installed as clustered. I want to move named
instance form non-clustered to clustered. What is ...

I'm trying to install MS SQL 2005 Standard x64 to a two node Windows Server
2003 R2 SP2 cluster.
I've setup the cluster as per MS requirements and tested failover, The
cluster seems to be working well.

Is there a utility (and if so where can I get it) to compare 2 MS Windows
2003 cluster nodes. Basically, I want to be able to compare drivers and
driver versions that have been installed on each machine. They are part of
the same SQL Server Cluster and one of them (Node B) is not ...

Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are

I'm a little confused how best to setup a new 2005 deployment. I'm
moving from a 2000 environment, which used Legato's AAM software to
support failover. The new environment will use MS clustering.
The 2000 setup has multiple instances on each node, and each instance

I got an interesting post yesterday on this site where the person pointed out
that with Mirroring you could apply a service pack on the Mirror, take an
outage of a few seconds on the principal and then make the Mirror the
Principal and then apply the service pack to the original ...

how to find out if a TSQL table is being updated?
for example if someone does an update to a table that takes a long time, is
there anyway for me to check the status of that update process?

when calling UPDATE from the result set of a SELECT statement, is the order
in which rows from the SELECT statement 100% geronteed?
tableA
myid