How to detect if ms sql server 2000 is installed

Hi there, does anyone know how to detect sql server on a machine? I´ve read the archives on how to detect if ... is installed, and I looked in the registry under HKLM Software\Microsoft\Microsoft SQL Server to do something similar, but I´m not too sure which field to test against.
There is one there, InstalledInstances, that I even tried to read from, but which instruction should I use to read from it? Neither ReadRegD nor ReadRegStr worked.

Thanks for any help in advance.

Jorge

The instruction you need to use depends on the key's type. What does RegEdit report as the type?

It says it´s a REG_MULTI_SZ, which should be binary, I guess. At least if I try to modify the value in the registry, it says it´s binary.
Now I´ve searched the forum for how to read binary values from the registry and from what I understand, that´s not possible. So I guess I want to know if anyone knows any other registry key I can read that tells me whether ms sql is installed.
Thanks for the quick reply, kichik.

REG_BINARY is binary... REG_MULTI_SZ is multi string. You should modify REG_MULTI_SZ Reader to your needs.

Thanks, man!

Jorge

I wrote some functionality to do this and posted it in the archives.



(well I wrote it last week, but posted it today =)

-m-