Find the location of OSQL

[BruceMcK]

Does anyone know of a simply way to find the location of the \\binn folder for the SQL Server instance you are installing?

I can obtain the path to the SQL install using the following T-SQL, but I can't get the output param back into the IA script:

EXEC master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\\Microsoft\\MSSQLServer\\Setup',
'SQLDataRoot', @param = $OSQL_PATH$ OUTPUT

[MichaelNesmith]

Would Read Registry help with this?

[BruceMcK]

Yep, that will get me the info I'm after. Thanks.