you can also use xp_regread to query the apprpriate registry values for your SQL server instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉