TcpFlag Property
后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。
The TcpFlag property specifies whether the TCP/IP Sockets Net-Libraries hide flag is set on a computer running an instance of Microsoft SQL Server.
语法
object. TcpFlag [= value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetTcpFlag(LPBOOL pRetVal);
HRESULT SetTcpFlag(BOOL NewValue);
备注
When you install an instance of SQL Server, SQL Server Setup creates an entry in the Microsoft Windows registry that enables clients to see SQL Server in SQL Server Management Studio.
For security purposes, you can set TcpFlag to TRUE to hide a server on the network. Clients can still connect to it, but they cannot see the hidden server when viewing servers. You can reveal the server by setting TcpFlag to FALSE.
To set the TcpFlag property, you must be a member of the sysadmin fixed server role.
注意: |
---|
If an application calls TcpFlag on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned. |
重要提示: |
---|
Setting the TcpFlag property changes registry settings, and it should be used with caution. |