eZeeNow.com

it's your's

How to read Windows Registry information in SQL (T-SQL)

This  Following T-SQL Will used to read the system Windows Registry.


EXEC master..xp_instance_regread @rootkey = N'HKEY_LOCAL_MACHINE',
@key = N'SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server\\100\\SQL'


xp_instance_regread
xp_instance_regaddmultistring,
xp_instance_regdeletekey ,
xp_instance_regdeletevalue ,
xp_instance_regenumkeys ,
xp_instance_regenumvalues ,
xp_instance_regremovemultistring ,
xp_instance_regwrite

All above all undocumented stored procedures and could easily change from release to release.

Loading