xp_instance_regwrite syntax

最新推荐文章于 2019-07-23 00:25:19 发布

转载最新推荐文章于 2019-07-23 00:25:19 发布 · 495 阅读

0 ·

CC 4.0 BY-SA版权

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

文章标签：

#数据库

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

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