Delete from Registry using SQL | SansSQL

Wednesday, July 16, 2008

Delete from Registry using SQL

xp_regdeletekey and xp_regdeletevalue are the two undocumented stored procedures that helps in deleting values and keys from registry. These stored procedures should be used very vary carefully as there are chances of harming the system and system may crash.

xp_regdeletekey
This is an extended stored procedure that will delete an entire key from the registry.
EXEC xp_regdeletekey @rootkey,@key
Example:-
EXEC master..xp_regdeletekey @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Test'

xp_regdeletevalue

This is an extended stored procedure that will delete a particular value for a key in the registry.

EXEC xp_regdeletevalue @rootkey,@key,@value_name

Example:-

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

4 comments:

Huongkv said...

Mua vé tại đại lý vé máy bay Aivivu, tham khảo

Vé máy bay đi Mỹ

đăng ký về việt nam ở mỹ

giá vé máy bay từ nhật về việt nam

giá vé máy bay từ đức về việt nam

từ canada về việt nam quá cảnh ở đâu

ve may bay vietnam airline tu han quoc ve viet nam

khách sạn cách ly

vé máy bay chuyên gia nước ngoài

Anonymous said...

Garage door companies in CT offer a wide range of services and products for garage doors. They install, repair, and maintain garage doors. They also offer emergency services 24/7 in case of any emergency such as when your garage door is stuck or broken.

MartenJames said...

Well explained article to use SQL in better way. By getting our Commercial Electrical Services Los Angeles CA, you can get reasonable rates, certified electricians, quality material, and emergency services.

Micheal Jackson said...

I've seen businesses leverage the creativity of designers like Shaheryar Q. on Upwork to create postcards design for your business
that grab attention and convey their brand message effectively.

Post a Comment

Ads