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