Philip,

Can you tell us how the 36 disks are configured?  Do you have several smaller raid 1+0 arrays or 1 big one with 36 disks?

I ask because I've done some...

You could always log out before doing anything.  That should reduce it to zero.

Smile.  It's Friday!

Sergiy do you have a cursorless solution for this one?

rangark, that might work, but I don't recall ever seeing DBCC CHECKIDENT performing any modifications to the repl_identity_range_pub_....  constraints, which are set by the inner workings of merge replication.

jg

Can you connect to the remote SQL server from Query Analyzer using the SS user and password?

You are getting the error because your inserted identity violates a check constraint.  For some reason, something is intercepting the normal constraint violation error message and replacing it with the...

And the physical disk resources must be a dependency of the SQL server resource in the resource group.

Ted,

Do you have Terminal Services installed on your cluster?  SQL won't work on a cluster that has that component installed.  Remote Administration is fine, but not terminal services.

See http://support.microsoft.com/kb/301520/

hth...

Every time you use XML, God kills a kitten.

Hello,

What Lowell said.  

For now, and to directly answer the question, you can use the hint "WITH (INDEX =0)" like so:

Select fruit, animal from things WITH (INDEX = 0)

where color =...

I am not allowed to do business with Sony.  Too bad, because they have some good stuff out there.  If they change their ways, they may someday become an approved vendor...

The /3GB switch is not intended as a SQL server startup parameter.

You say that the box won't start, but how would you re-insall SQL server on a box that won't...

Can you post the exact error message? 

I can think of two things that might do what you are talking about:

1. Using XML in queries incorrectly.  This will definitely cause...

There is a newer KB article that may apply for you:

http://support.microsoft.com/kb/839279

It describes how to configure the firewall service to allow DTC to work.  Interestingly, it seems that the problem...

Every time you use sp_xml_preparedocument, God kills a kitten.

Remeber that.

heh