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 BI Templates to Visual Studio 2005 - 2008

After installing SQL Server (both 2005 and 2008) sometimes the BI Templates are missing from the new project dialog. Is there a way to find those templates and add them after a SQL Server install? I have searched the web and Microsoft MSDN, but found no information. Thank you if you can help me.

Hi,

From your description, do you mean the Business Intelligence project template disappear in the create project dialogue?

Based on my understanding, you can try to open "SQL Server Business Intelligence Development Studio" from SQLServer 2005 menu group instead of starting Visual Studio designer. If you still can't find the business intelligence project template. Please make sure that if you have choose the "SQLServer Reporting Service" to be installed while you installing the SQLServer2005.

Thanks.

|||

No, the problem is that they do not appear in VS/BIDS even if SSRS is installed. The templates must be available on the web somewhere and the correct folder location and configuration to add them to the VS/BIDS interface must exist somewhere.

Adding a version 7 DB to SQL2000

I would like to add a version 7 DB to my SQL 2000 Server. I was wondering if there was a way to add and upgrade it to version 2000 without installing version 7 on the machine? If I have to install 7, what is the best procedure with an existing install of 2000? Any help would be greatly appreciated.You can use either BACKUP/RESTORE or sp_attach_db
SQL Server 2K will automatically upgrade your database during restore or
attach process.
After you will restore or attach your database it is suggested to make
update statistic and if it is possible database re-indexation.
Regards
---
All information provided above AS IS.
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.|||Hi Tony
Can you elaborate on what you mean? Do you have backups of a SQL 7 db or the
actual .mdf and .ldf files?
If you have a backup, you can restore a SQL 7 backup to a SQL 2000 server,
if you have the files, you can use sp_attach_db.
Please read about the appropriate topic RESTORE or sp_attach_db in the Books
Online.
You do not need to install SQL 7.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.|||What is it you have exactly? Is it a backup or just the detached files? In
either case it should not be a problem as the upgrade happens automatically
when you attach or restore it.
--
Andrew J. Kelly
SQL Server MVP
"TonyHeuft" <theuft@.cha.ab.ca> wrote in message
news:2AE0F362-5E3A-496C-A0B6-D1B8237BF92C@.microsoft.com...
> I would like to add a version 7 DB to my SQL 2000 Server. I was wondering
if there was a way to add and upgrade it to version 2000 without installing
version 7 on the machine? If I have to install 7, what is the best procedure
with an existing install of 2000? Any help would be greatly appreciated.

adding a version 7 DB

What would be the quickest way to add a version 7 DB to SQL Server 2000? Can I do it without installing 7? I have a server with 2000 and would like to add the 7 DB without installing 7. Can I do it and if not, what is the best method for accomplishing what I am trying to do? All help will be greatly appreciated.You can restore a SQL 7 backup onto SQL 2000 and it will automatically
upgrade the database.
"TonyH" <theuft@.cha.ab.ca> wrote in message
news:3A92562F-9C65-46EF-8F98-DFE14793F2E0@.microsoft.com...
> What would be the quickest way to add a version 7 DB to SQL Server 2000?
Can I do it without installing 7? I have a server with 2000 and would like
to add the 7 DB without installing 7. Can I do it and if not, what is the
best method for accomplishing what I am trying to do? All help will be
greatly appreciated.|||Hi Tony
You have 3 answers to the previous post in which you asked this question 30
minutes ago.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"TonyH" <theuft@.cha.ab.ca> wrote in message
news:3A92562F-9C65-46EF-8F98-DFE14793F2E0@.microsoft.com...
> What would be the quickest way to add a version 7 DB to SQL Server 2000?
Can I do it without installing 7? I have a server with 2000 and would like
to add the 7 DB without installing 7. Can I do it and if not, what is the
best method for accomplishing what I am trying to do? All help will be
greatly appreciated.