通过 t-sql 脚本启用 TCP/IP 协议? [英] Enabling TCP/IP protocol through t-sql script?

问题描述

如何在 sql server 2008 上通过 t-sql 脚本启用 tcp/ip?

How to enable tcp/ip through t-sql script on sql server 2008?

推荐答案

为了使用 t-sql 脚本执行此操作，您可能需要修改注册表设置.我在使用 t-sql 之前没有这样做过，所以帮不上什么忙.但您可能想查找 xp_instance_regread 和 xp_instance_regwrite.它们是允许您读/写注册表值的扩展存储过程.

In order to do that using a t-sql script, you might have to fiddle with the registry settings. I haven't done that before myself using t-sql so can't be of much help. But you may like to look up for xp_instance_regread and xp_instance_regwrite. They are extended stored procedures which allow you to read/write registry values.

这是一个可能有帮助的例子 - http://codebetter.com/blogs/raymond.lewallen/archive/2005/09/12/131869.aspx

Here is an example which might be of some help - http://codebetter.com/blogs/raymond.lewallen/archive/2005/09/12/131869.aspx

以下链接应该可以帮助您找到注册表中 TCP/IP 设置的下落.http://support.microsoft.com/kb/315236

The following links should help you locate the whereabouts of TCP/IP settings in the registry. http://support.microsoft.com/kb/315236

http://www.pctools.com/guides/registry/detail/1171/

干杯

这篇关于通过 t-sql 脚本启用 TCP/IP 协议?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！