Was this database created fresh? Or was it detached/attached or backed up / restored.

-Carlos

MikeyMikey brought up a good point. However, if that was the case Windows would only see one CPU as well.

-Carlos

Ok guys. I have a few SQL2000 servers with DUAL CPUs, none of them give me the issues discussed above.

Here is the configuration I have on EM.

http://www.appliedi.net/carlos/sql.htm

Hope this helps.

-Carlos

Andy,

Thanks for the info. I will my client know that it will not be possible.

-Carlos

exec sp_msforeachtable " sp_changeobjectowner @objname= , @newowner='dbo' "

This one has saved me a ton of time. It will do the whole DB at once.