Home Forums SQL Server 7,2000 Administration XP_INSTANCE_REGREAD RE: XP_INSTANCE_REGREAD
tknoobOLD
Ten Centuries
Points: 1183
More actions
January 11, 2007 at 3:38 pm
#682794
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