• Try using xp_regread, such as:

    declare

    @rc int,

    @dir

    varchar(5)

    exec

    @rc = master.dbo.xp_regread

    'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll','TcpPort', @dir output

    select @dir

     

    Tim