Hi Tim,

For SQL 2005 or SQL 2008 (i assume you use one of them) you need to find the
following registry key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL]
"SQLEXPRESS"="MSSQL.1"

Based on the value of the name of the instance ("SQLEXPRESS" in this
example) you'll find the instance name-id.
Using this instance name-id you can now get the registry value:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]
"SQLDataRoot"="C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL"

SQLDataRoot is the one you're searching ;)

For SQL 2000 it's even more simple but i'll leave the for you to find out :)
(Hence: start regedit on a SQL 2000 machine and try to find the key
mentioned above)

Regards,

Albert van Peppen


-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to