How to determine what components are installed for SQL 2005 Express

We have serveral app groups that have installed SQL 2005 Express, but each group have installed different components. How can I determine, specifically if the following components were previously installed.

ADDLOCAL=SQL_Engine
ADDLOCAL=SQL_FullText
ADDLOCAL=RS_Server

And if not installed re-install with the missing component?

Thanks

Tony Z

There are two approaches you can check.

1. You can go Control Panel --> Add/Remove Program. Select the SQL Express entry and choose Update. Then you can see the components installed.

2. On x86 machine, check the regsigry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup : FeatureList

On x64 machine, check the corresponding WOW registry key.

how to determine sp level at app install time?

Hi,
I have an application that uses an instance of MSDE we create. What should
our installer check to find out if we need to install msde sp3, when our
users upgrade our software?
thanks,
David
Hi,
Installation of ur application require a valid login to sql server right,
then you could verify the service pack by executing the below query.
SELECT SERVERPROPERTY('PRODUCTLEVEL')
This returns SP3 if the service pack installed is SP3. Based on this u could
continue the installation.
Thanks
Hari
SQL Server Mvp
"David Burson" <DavidBurson@.discussions.microsoft.com> wrote in message
news:C52717FF-A27E-4686-89ED-01AA4FDAF179@.microsoft.com...
> Hi,
> I have an application that uses an instance of MSDE we create. What
> should
> our installer check to find out if we need to install msde sp3, when our
> users upgrade our software?
> thanks,
> David
|||Thanks Hari,
We have a problem with that solution though. I guess we need to use osql to
run the serverproperty query, but we don't know how to run it so that the
user doesn't see it run, and also we don't know how to get the response from
osql back into our installer code.
Do you have any suggestions on how to handle those issues?
Thanks very much!
David
"Hari Prasad" wrote:

> Hi,
> Installation of ur application require a valid login to sql server right,
> then you could verify the service pack by executing the below query.
> SELECT SERVERPROPERTY('PRODUCTLEVEL')
> This returns SP3 if the service pack installed is SP3. Based on this u could
> continue the installation.
> Thanks
> Hari
> SQL Server Mvp
> "David Burson" <DavidBurson@.discussions.microsoft.com> wrote in message
> news:C52717FF-A27E-4686-89ED-01AA4FDAF179@.microsoft.com...
>
>

how to determine how many users web sql will support?

Hello,
We are writting a small pc monitor app that sends pc statistics (hd free,
mem free etc) to a hosted sql server every hour. The pc's also do a select
query to see if there are any messages for it every 30 seconds. We may have
up to 1000 computers doing this. How do I make sure our hosted SQL server
can handle this performance wise?
My other concern is that all 1000 will hit the sql at nearly the same time
cause extreme delays. Any suggestions?
Thanks!
Matt
> up to 1000 computers doing this. How do I make sure our hosted SQL server
> can handle this performance wise?
There is no magic formula, it will depend on a number of things, such as
amount of data being transferred, bandwidth, hardware, table
structure/indexes, concurrency of inserts, concurrency of inserts/updates
vs. selects, etc. I suggest you look into some load testing software, e.g.
there is a list here for web-based apps http://www.aspfaq.com/2139
For the database specifically, you can use profiler, Database Hammer from
the SQL Server 2000 Resource Kit, SQL Load Simulator 2.0 (SQLLS2) that comes
with the Back Office Resource Kit 4.5, or some of these:
http://www.mercury.com/us/products/performance-center/
http://www.benchmarkfactory.com/comm...tent.asp?PID=1
http://www-306.ibm.com/software/awdt...nce/index.html
http://www.sqlpower.com/products.html

how to determine how many users web sql will support?

Hello,
We are writting a small pc monitor app that sends pc statistics (hd free,
mem free etc) to a hosted sql server every hour. The pc's also do a select
query to see if there are any messages for it every 30 seconds. We may have
up to 1000 computers doing this. How do I make sure our hosted SQL server
can handle this performance wise?
My other concern is that all 1000 will hit the sql at nearly the same time
cause extreme delays. Any suggestions?
Thanks!
Matt> up to 1000 computers doing this. How do I make sure our hosted SQL server
> can handle this performance wise?
There is no magic formula, it will depend on a number of things, such as
amount of data being transferred, bandwidth, hardware, table
structure/indexes, concurrency of inserts, concurrency of inserts/updates
vs. selects, etc. I suggest you look into some load testing software, e.g.
there is a list here for web-based apps http://www.aspfaq.com/2139
For the database specifically, you can use profiler, Database Hammer from
the SQL Server 2000 Resource Kit, SQL Load Simulator 2.0 (SQLLS2) that comes
with the Back Office Resource Kit 4.5, or some of these:
http://www.mercury.com/us/products/performance-center/
http://www.benchmarkfactory.com/com...ntent.asp?PID=1
http://www-306.ibm.com/software/awd...ance/index.html
http://www.sqlpower.com/products.htmlsql

how to determine how many users web sql will support?

Hello,
We are writting a small pc monitor app that sends pc statistics (hd free,
mem free etc) to a hosted sql server every hour. The pc's also do a select
query to see if there are any messages for it every 30 seconds. We may have
up to 1000 computers doing this. How do I make sure our hosted SQL server
can handle this performance wise?
My other concern is that all 1000 will hit the sql at nearly the same time
cause extreme delays. Any suggestions?
Thanks!
Matt> up to 1000 computers doing this. How do I make sure our hosted SQL server
> can handle this performance wise?
There is no magic formula, it will depend on a number of things, such as
amount of data being transferred, bandwidth, hardware, table
structure/indexes, concurrency of inserts, concurrency of inserts/updates
vs. selects, etc. I suggest you look into some load testing software, e.g.
there is a list here for web-based apps http://www.aspfaq.com/2139
For the database specifically, you can use profiler, Database Hammer from
the SQL Server 2000 Resource Kit, SQL Load Simulator 2.0 (SQLLS2) that comes
with the Back Office Resource Kit 4.5, or some of these:
http://www.mercury.com/us/products/performance-center/
http://www.benchmarkfactory.com/common/content.asp?PID=1
http://www-306.ibm.com/software/awdtools/tester/performance/index.html
http://www.sqlpower.com/products.html