Viewing 5 posts - 1 through 5 (of 5 total)
Was this database created fresh? Or was it detached/attached or backed up / restored.
-Carlos
December 15, 2003 at 12:20 pm
#486242
MikeyMikey brought up a good point. However, if that was the case Windows would only see one CPU as well.
April 24, 2003 at 10:33 am
#455260
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.
April 24, 2003 at 10:04 am
#455244
Andy,
Thanks for the info. I will my client know that it will not be possible.
April 9, 2003 at 8:32 am
#453571
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.
September 3, 2002 at 1:45 pm
#435874