注册表

[daijingjie2002]

怎样通过存储过程，或sql函数修改注册表？

[skyboy0720]

3楼,

do not know

[xiaoliaoyun]

用存储过程
写:xp_instance_regwrite
读:xp_instance_regread

举例
xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',N'AuditLevel', REG_DWORD,0

作用
将启动方式改为"仅windows"

[zjcxc]

xp_regdeletekey
This extended stored procedure will delete an entire key from the registry.
You should use it very carefully.

Syntax:

EXECUTE xp_regdeletekey [@rootkey=]'rootkey',
[@key=]'key'




For example, to delete the key 'SOFTWARE\Test' from 'HKEY_LOCAL_MACHINE', run:

EXEC master..xp_regdeletekey
@rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Test'




xp_regdeletevalue
This extended stored procedure will delete a particular value for a key in
the registry. You should use it very carefully.

Syntax:

EXECUTE xp_regdeletevalue [@rootkey=]'rootkey',
[@key=]'key',
[@value_name=]'value_name'




For example, to delete the value 'TestValue' for the key 'SOFTWARE\Test'
from 'HKEY_LOCAL_MACHINE', run:

EXEC master..xp_regdeletevalue
@rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Test',
@value_name='TestValue'




xp_regread
This extended stored procedure is used to read from the registry.

Syntax:

EXECUTE xp_regread [@rootkey=]'rootkey',
[@key=]'key'
[, [@value_name=]'value_name']
[, [@value=]@value OUTPUT]




For example, to read into the variable @test from the value 'TestValue'
from the key 'SOFTWARE\Test' from the 'HKEY_LOCAL_MACHINE', run:

DECLARE @test varchar(20)
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Test',
@value_name='TestValue',
@value=@test OUTPUT
SELECT @test




xp_regwrite
This extended stored procedure is used to write to the registry.

Syntax:

EXECUTE xp_regwrite [@rootkey=]'rootkey',
[@key=]'key',
[@value_name=]'value_name',
[@type=]'type',
[@value=]'value'




For example, to write the variable 'Test' to the 'TestValue' value, key
'SOFTWARE\Test', 'HKEY_LOCAL_MACHINE', run:

EXEC master..xp_regwrite
@rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Test',
@value_name='TestValue',
@type='REG_SZ',
@value='Test'

[hmily1688]

邹键什么也会啊。PFPF，

[hmily1688]

原来我见过竹之草写过

[internetcsdn]

1楼,

do not know

[DigJim]

2楼,

do not know