how to find MS SQL Server 2000/2005 is installed or not through registry ?

[nrupeshpt]

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

[hidenori]

You just need to issue the following SQL statement to the target Microsoft database server in order to retrieve the information:

SELECT @@VERSION

[nrupeshpt]

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.