Thank you everyone! When I run the query, I am getting the following:

Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

I just wanted to THANK everyone again. This is a great community!

No paul, I didnt see them when I posted. Thanks again.

Thanks Paul! Do you happen to have the white paper on that?

After reading what you recommended, should I be seeing 64 cpu's on the SQL 2008 boxes? Why am I seeing 20 cpu's on one and 40 cpu's on the...

One more thing to note. OS = Windows 2008 Enterprise SP1

In my case, I have four servers. Two of them running SQL 2008 and the other two running SQL 2008 R2. The two running R2 are showing 80...

I want SQL server 2008 to see all 80 CPU's the same way SQL sever 2008 R2 is. My apologies if I was not clear. Thank you for your...

Just to be clear, you are saying to ensure hyperthreading is active on ALL CPU's, correct?

I'll disable hyper-threading tomorrow and let you know the outcome.

Thank you for your assistance!

Would this be an issue if the OS is seeing it correctly? In Task Manager I can see all 80 processors, it's just SQL that is not see them...

No - Three are HP's DL580 G7's and one is a Dell PowerEdge R910.

Thank you very much. I identified the DB which had ownership and changed to sa. I am now able to login. Thank you for all your help.

I apologize for my ignorance. Can you please send me an example on how to change ownership of the master DB in sqlcmd mode? Thank you soo much.

Does this mean it's making a connection?

C:\Program Files\Microsoft SQL Server\100\Tools\Binn>sqlcmd -E -S .\injest -A -Q"alter login [sys-ad

min] with name = sa"

Msg 15151, Level 16, State 1, Server ICMDBORSTG\INJEST,...