xp_instance_regwrite syntax

weixin_33888907

于 2019-06-26 03:21:15 发布

阅读量476

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/flysun0311/archive/2012/08/28/2660021.html

本文介绍了 SQL Server 中未被官方文档详细记录的存储过程 xp_instance_regwrite 的使用方法，该存储过程可用于更新 SQL Server 相关的注册表设置，例如调整错误日志文件的数量。需要注意的是，操作注册表可能带来风险，因此使用时应谨慎。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

The stored procedure "master.sys.xp_instance_regwrite" is not documented in SQL Server Books Online (BOL), but is usefull. In general the syntax is
EXECUTE [master].[sys].[xp_instance_regwrite] @rootkey = N'<name of root key>' ,@key = N'<key name>' ,@value_name = N'<key name value>' ,@type = N'<key type>' ,@value = <key value>;

For example the number of SQL Server Errorlog files can be updated by the statement
EXECUTE [master].[sys].[xp_instance_regwrite] @rootkey = N'HKEY_LOCAL_MACHINE' ,@key = N'Software\Microsoft\MSSQLServer\MSSQLServer' ,@value_name = N'NumErrorLogs' ,@type = N'REG_DWORD' ,@value = 42;

Use with caution!

The parameter @type takes a value without N'' around (@type = <key type>), but I like the Unicode framing. This way I try to avoid difficulties when building the values outside the call.

转载于:https://www.cnblogs.com/flysun0311/archive/2012/08/28/2660021.html