I don't wish to appear rude or offensive but to be honest reading your posts I'd probably say a training course would be beneficial.

I suppose the Project Manager knows nothing about SQL Server?

I try to never use cursors unless there is no other way or I'm attempting to stress test a server ,...

ummmmm.......  OK so clusters are managed using cluster manager, from there you can find out your info. I don't know of many good books on clustering - I have one ...

You should get to SP4 and the rollup ( 2187 ) that follows. SP4 has a few problems ( I'm told ) which the rollup fixes. To have a patch...

There's plenty in BOL and Technet about dbcc commands.  Asking for this type of help is way to vague and doesn't help us help you. Consistancy errors are bad news...

If you get hold of the sql 2000 resource kit there is an electronic diagram of the system tables you might find interesting, however - word of warning - don't...

Is this an active/active or active/passive cluster?

You should connect to the virtual server - select @@servername will give the virtual servername.( or go by ip )

sounds like you have a...

The whole point of a rdbms is the locking which assists in maintaining the integrity of the data. The art is to keep transactions as short and sharp as is...

I just moved the objects from within EM, although I think I scripted it too. Can't remember exactly now. - and I only had a couple of objects to move...

try  http://support.microsoft.com/Default.aspx?id=224587

I think it would have to use a constant scan to recover parameters passed in the statements. I'd suggest you use profiler to capture the query plan, rather...

I think, and it's a long time since I saw this, that the client wraps the proc call into an executable string, sql server then sees this as an ad-hoc...

Hmmm .. adv server to std server .. well, I think you'll lose a bit of performance. You don't say which editions of sql server you're using.  A 4 disk...

It's probably set options, if you look in the proc cache are the setops different?

script out your offending proc, the first lines should be

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE  ...

You're not totally correct concerning a HEAP, some rdbms allow the table and index structures to be defined ( not all B Tree's by default )  heaps do not always fragment....

Yup she needs to be a dbo and prefix her code with the dbo. prefix when creating objects. Or pass the scripts to someone who is dbo. Do you really...