Using T-SQL to Manipulate the Registry

xp_regwrite—This extended stored procedure creates new registry subkeys and subkey values. You can use xp_regwrite when you want to write something into the registry on the SQL Server from a client computer. To invoke xp_regwrite, use the syntax that Listing 3 shows. This code example creates a new subkey called Test that has the value TestValue in the HKEY_LOCAL_MACHINESOFTWARE subkey.

xp_regread—This extended stored procedure returns a value for a registry entry that you specify. To invoke xp_regread, use the syntax that Listing 4 shows. This code example returns a value for the HKEY_LOCAL_MACHINESOFTWARETestTestValue subkey into the @test variable.

xp_regdeletevalue—This extended stored procedure deletes a specified subkey's value from the registry. Use it carefully. To invoke xp_regdeletevalue, use the syntax that Listing 5 shows. This code example deletes the TestValue value from the HKEY_LOCAL_MACHINESOFTWARETest subkey.

xp_regdeletekey—This extended stored procedure deletes keys from the registry. Invoke it carefully by using the syntax that Listing 6 shows. This code example deletes the Test subkey from the HKEY_LOCAL_MACHINESOFTWARE subkey.