This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: how to find MS SQL Server 2000/2005 is installed or not through registry ?
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 05, 2008
07:58 PM
how to find MS SQL Server 2000/2005 is installed or not through registry ?
I am preparing an install package. During the installation I need to run few SQL statements. For this I need to determine whether the person installing my package has some sort of Microsoft database installed on his machine or not, how do it check this?
My package runs on SQL Server 2000 to SQL2005 Express, some of the clients may have SQL Server 2000 and some may be running just SQL2005 Express so I should be able to find either or both but how ???
Thanks in advance
Nrupesh
My package runs on SQL Server 2000 to SQL2005 Express, some of the clients may have SQL Server 2000 and some may be running just SQL2005 Express so I should be able to find either or both but how ???
Thanks in advance
Nrupesh
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 06, 2008
09:01 AM
You just need to issue the following SQL statement to the target Microsoft database server in order to retrieve the information:
SELECT @@VERSION
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 06, 2008
05:30 PM
But what if there is no DATABASE SOFTWARE, Thats what i want to find out first! and so I cannot use SQL statements I will have to do it through registry only.