how to know SQL server Express is installed in XP and Vista ?

[Denver Thomas]

hi friends... how to know SQL server Express is installed in XP and Vista.Anyway to check that ?..registry keys or somethin like that.I hav to create a setup ..before that I need to check whether SQL Server Express 2005 is installed or not.It wil be very helpful for me if you explains with sufficient codes. With warm regards denver

[Zoltan Balazs]

Use WMI. Here is a sample[^]

Work @ Network integrated solutions | Flickr | A practical use of the MVC pattern

[Bert delaVega]

Not sure if this is what you're asking, but you can make SQL Server Express 2005 a prerequisite in your installation: In your deployment project: - right click, select properties - click prerequisites - Check SQL Server and whatever options