When I creare a non clustered index , I get error as show below ,
  Server: Msg 1904, Level 16, State 1, Line 1
Cannot specify more than 16 column names for statistics or index key list.
21 specified.

I need urgent help on SQL 2000 cluster based on Windows 2003 SP1. I have SQl
2000 cluster with one virtual server on Windows 2003 connected to HP EVA 5000
SAN. One of my node failed  & did basic steps like Evict the node & so on
from exisitng setup. Later I built the node again ...

Hi, we have an active/passive cluster which hosts our production database.
Transactional replication is being made from the production to a 'reporting'
database residing on a lone server. We will need to install Analysis service
for the construction of cubes.

Can someone briefly explain why SQL Server Agent and MSSQLSERVER are
currently reading:  "Manual"/"Started" in Services.msc?  I figure it must be
a clustering thing.
On the Passive node cluster the services are not started, but just manual.

Is it possible to have different versions of SQL Server 2005 clustered as
various nodes. ie:
Node 1 - Sql server 2005 Enterprise
Node 2 - Sql server 2005 Standard

Hi, where I can find a guide step-by-step to add a second node to
existing sql2005 cluster?
I have installed an istance only on first node and now I want add the
second one.

I need urgent help on SQL 2000 cluster based on Windows 2003 SP1. I have
SQl 2000 cluster with one virtual server on Windows 2003 connected to HP
EVA 5000 SAN. One of my node failed  & did basic steps like Evict the
node & so on from exisitng setup. Later I built the node again with ...

We had an error over the weekend of mass porportions(Sunday 3pm PST).  Long story short; the model database was detached and the SQL Server was stopped, with it still detached.  This happened to happen on our primary Production Database Clustered Server which is the ...

I got this error occasionally. I am using two nodes SQL
Server 2000EE cluster running on Win server 2003, it's an
Active/Passive configuration, and they pull data from a
public external RAID. I have applied all latest SPs and

Just want to know is it possbile to configure a 3-nodes (A/A/P) SQL
Server 2000 cluster running on Windows 2000 advance OS?  Btw, any
website or whitepaper can I refer to?
Thanks in advance!

I have windows 2003 sp1 running in a 2-node cluster.  The cluster is running
sql sp4.  I tried failing over my cluster after a windows update and i'm not
sure if that's what threw my server's off or something else.  But here's the
situation.  I currently have the cluster group ...

We have an 2-node Active/Active SQL 2000 SP3a cluster on Windows 2003.
Accordingly we have 2 instances of SQL, INST1 on node 1 and INST2 on node2.
I think our db admin did a "no no" a few weeks back.  Having an issue with
something SQL related, she changed the MSSQL$INST2 service ...

I have Sql 2000 on Windows 2003 server, i would like to be notified when
cluster fail over accours. How can i do this.
Your help is greatly appreciated.

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.

We are thinking about setting up an Active\Active\Passive configuration on
64 bit SQL Svr 2005 instances. Is it possible? Documentation available
anywhere?
mpighin@msn.com