Archive

Posts Tagged ‘xp_regdelete’

Accessing Registry using XPs (contd..) – TSQL

11.05.2011 No comments

We can use the xp_regwrite undocumented extended stored procedure to write new entries to Windows registry.

You need to provide the key path, A new key will be created if it does not exist.

The following code will add a new entry in startup programs list in registry:

— © 2011 – Vishal (http://SqlAndMe.com)

EXEC master..xp_regwrite
     @rootkey     = 'HKEY_LOCAL_MACHINE',
     @key         = 'SoftwareMicrosoftWindowsCurrentVersionRun',
     @value_name  = 'Solitaire',
     @type        = 'REG_SZ',
     @value       = 'C:Program FilesMicrosoft GamesSolitaireSolitaire.exe'

 

Output returned by the procedure will be '(0) rows affected', unless it encounters an error.

 

To verify the entry, you need to open Registry Editor and traverse to specified path.

 

image

 

Or you can also use xp_regread or xp_instance_regread to verify the entry.

 

You can delete an registry entry using xp_regdelete.

 

— © 2011 – Vishal (http://SqlAndMe.com)

EXEC master..xp_regdeletevalue
     @rootkey     = 'HKEY_LOCAL_MACHINE',
     @key         = 'SoftwareMicrosoftWindowsCurrentVersionRun',
     @value_name  = 'Solitaire'

 

Output returned by the procedure will be '(0) rows affected', unless it encounters an error.

 

Hope This Helps!

Vishal