Instructions accepted.  I should have checked a profiel of EM.

But, your syntax worked like a charm though and I do appreciate your help

Just an extra word of caution.

I had a lot of trouble with SP3a on active/active clusters.  Found that it updates files used by all instances - EVERY time you upgrade...

I recently read (and I'm sorry I can't find the reference now) how adding constraints with a nocheck option can cause query result problems. 

It went something like this:

SQL will...

The same thing that would happen if you shut down SQL and restarted it.  The jobs stop executing.  I believe you don't have a job history becuase it is written...

The following way to find indentities is returning invalid results:

SELECT table_name, column_name, ordinal_position orgPostion, data_type

  FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)

 where COLUMNPROPERTY (OBJECT_ID(Table_Name),Column_Name,'IsIdentity') = 1

order by table_name, column_name

It returns an integer field from...

I understand your point.  But, I think you were harsh on the writer.  I appreciated his point of view.

Whether you want to argue that the DB shouldn't have been designed that way is a mute point.  DBAs often have to clean up what others do and sometimes even make...

Yes, that help tremendously with the text. 

My guess with what I know is that if your page is full but you have ghost records also(ie logically free space) and then...

This ghost record is the 'slot' I mentioned.  Compaction is suposed to clean up the ghost records.  When Compaction occurs, and these 'ghost' records are cleaned up, does SQL rewrite...

I haven't finished digesting all the new information but am certain I will find more information than I know now.  Thank you for the links.

The ghost records were what compaction...

When you say new users have the problem, do you mean if you set up a new (never before used)domain account that does not have any SQL access, then you give him...

Thanks I had forgotten the restart instructions.

If you have jobs you also need to change the name of the originating server or SQL won't let you edit the jobs - it thinks they were from another...

Yes, I know the cluster account must be added, but it doesn't work to well (from my experience) without the nt authority\system.  Maybe there was another misconfiguration causing this.  Maybe...

Don't forget that you need to add 'NT Authority\System' as an SA also otherwise certain functions that the server is performing will not work with builtin administrators removed.  Cluster perform...