23rd April 11:18
Reading Registry Entries...
You have a couple of options..
1. Use undo***ented xp_Regread & xp_RegWrite extended procedures:
DECLARE @v varchar(20)
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
EXEC master..xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
Note that these are undo***ented & hence are not recommended as a stable
2. Use sp_OA* procedures:
The invocation of a COM object using sp_OA* procedure is under the security
context of the SQL Server service account. Since this may prevent
reading/writing the Registry, you have to run the service with sufficient
security permissions to access the registry.
( Please reply to newsgroups only )