Adding processors after the fact

Hello all,
When installing additional processor(s) into a Win Server 2003 w/SQL Server 2005 box after it is up and running, does the OS & SQL
Server need to be reinstalled, or will they automatically recognize the new processor(s)?
Thanks for any help anyone can provide,
Conan Kelly
Windows will automatically pick up the new CPUs, and SQL Server will find
whatever the OS has.
Now licensing, that is a different issue. Nothing automatic there. You must
license the new CPUs if necessary -depending upon version.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Conan Kelly" <CTBarbarin@.msn.com> wrote in message
news:cN%bh.403881$QZ1.187976@.bgtnsc04-news.ops.worldnet.att.net...
> Hello all,
> When installing additional processor(s) into a Win Server 2003 w/SQL
> Server 2005 box after it is up and running, does the OS & SQL Server need
> to be reinstalled, or will they automatically recognize the new
> processor(s)?
> --
> Thanks for any help anyone can provide,
> Conan Kelly
>

Adding processors after the fact

Hello all,
When installing additional processor(s) into a Win Server 2003 w/SQL Server 2005 box after it is up and running, does the OS & SQL
Server need to be reinstalled, or will they automatically recognize the new processor(s)?
--
Thanks for any help anyone can provide,
Conan KellyWindows will automatically pick up the new CPUs, and SQL Server will find
whatever the OS has.
Now licensing, that is a different issue. Nothing automatic there. You must
license the new CPUs if necessary -depending upon version.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Conan Kelly" <CTBarbarin@.msn.com> wrote in message
news:cN%bh.403881$QZ1.187976@.bgtnsc04-news.ops.worldnet.att.net...
> Hello all,
> When installing additional processor(s) into a Win Server 2003 w/SQL
> Server 2005 box after it is up and running, does the OS & SQL Server need
> to be reinstalled, or will they automatically recognize the new
> processor(s)?
> --
> Thanks for any help anyone can provide,
> Conan Kelly
>

Adding processors after the fact

Hello all,
When installing additional processor(s) into a Win Server 2003 w/SQL Server
2005 box after it is up and running, does the OS & SQL
Server need to be reinstalled, or will they automatically recognize the new
processor(s)?
Thanks for any help anyone can provide,
Conan KellyWindows will automatically pick up the new CPUs, and SQL Server will find
whatever the OS has.
Now licensing, that is a different issue. Nothing automatic there. You must
license the new CPUs if necessary -depending upon version.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Conan Kelly" <CTBarbarin@.msn.com> wrote in message
news:cN%bh.403881$QZ1.187976@.bgtnsc04-news.ops.worldnet.att.net...
> Hello all,
> When installing additional processor(s) into a Win Server 2003 w/SQL
> Server 2005 box after it is up and running, does the OS & SQL Server need
> to be reinstalled, or will they automatically recognize the new
> processor(s)?
> --
> Thanks for any help anyone can provide,
> Conan Kelly
>

Adding an autonumber column after the fact?

I have a csv file of quotes. I need to IMPORT the quotes into my SQL Server database. I created the table with an autonumber identity column, but the IMPORT fails because I can't INSERT NULL into my identity column. There is no option to autonumber or anything when I click the TRANSFORM button on the IMPORT wizard. So, I have decided to allow NULLS on the ID column and add the numbering later. I'd rather not have to manually number it, is there a way to do it with a query? I treid just setting it to not allow NULLS and to auto-incrememnt, but that didn't work...I would have asked you to use temp table for the import and then do INSERT INTO a table with IDENTITY SET. Now you do ANSI SQL ALTER TABLE to SET IDENTITY on the table. Run a search of ALTER table in the BOL (books online). Hope this helps.|||Thank-you for your help :)|||I am glad I could help.