Undocumented stored procedures: Registry manipulation in SQL Server 7.0 and 2000

Serdar Yegulalp, Contributor
You'll find a slew of undocumented functions in SQL Server 7.0 and 2000, most of them used by Microsoft to perform internal tasks that might change from version to version of the product.

Among these undocumented functions are a set of extended stored procedures used by SQL Server itself to obtain, set and delete Registry keys. This can come in handy if you're creating a SQL Server application that also has standalone binary components, and you want to use the Registry to track program settings between both the application and your database.

xp_regread

Function xp_regread reads a key from the Registry and writes the results to a user-supplied variable. 

EXEC xp_regread 
@rootkey=,@key=,@value_name=, 
@value= OUTPUT

Here is a variable to write the resulting key information. For instance, to read the value MyValue from SOFTWARE\MyKey in HKEY_LOCAL_MACHINE, and store the results in @outvar, you would use: 

EXEC xp_regread 
@rootkey='HKEY_LOCAL_MACHINE',@key='SOFTWARE\MyKey',@value_
name='MyValue', @value=@outvar OUTPUT

xp_regwrite

Function xp_regwrite writes a value to the Registry and works in much the same way. 

EXEC xp_regwrite 
@rootkey=,@key=,@value_name=, 
@type=, @value=

Keytype @type is, of course, one of the standard keytypes,

    Requires Free Membership to View

    Login

such as REG_SZ.

xp_regdeletekey

Function xp_regdeletekey removes an entire key:

EXEC xp_regdeletekey @rootkey=,@key=

xp_regdeletevalue

Function xp_regdeletevalue deletes a single value: 

EXEC xp_regdeletevalue @rootkey=,@key=, 
@value_name=

Use extreme caution when deleting keys, since it is entirely possible for you to delete keys used by other applications or the system. Note also that you may not be able to run any of these extended stored procedures without having administrative authority in SQL Server (i.e., the sa context or something similar to it).

About the author: Serdar Yegulalp is editor of the Windows Power Users Newsletter. Check it out for the latest advice and musings on the world of Windows network administrators -- and please share your thoughts as well!

More information from SearchSQLServer.com

  • Tip: Undocumented sp_gettypestring stored procedure
  • Tip: Find space occupied by all tables and indexes
  • Learning Center: Stored procedures


    • This was first published in July 2005

    Join the conversationComment

    Share
    Comments

      Results

      Contribute to the conversation

      All fields are required. Comments will appear at the bottom of the article.

      Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

      Back to top