Enumerates a list of available instances of Microsoft SQL Server.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
구문
‘선언
Public Shared Function EnumAvailableSqlServers As DataTable
public static DataTable EnumAvailableSqlServers ()
public:
static DataTable^ EnumAvailableSqlServers ()
public static DataTable EnumAvailableSqlServers ()
public static function EnumAvailableSqlServers () : DataTable
반환 값
A DataTable system object value that contains an enumerated list of information about the available instances of SQL Server. The table describes the different columns of the returned DataTable.
Column |
Data type |
Description |
Name |
The name of the instance of SQL Server. |
|
Server |
String |
The name of the server on which the instance of SQL Server is installed. |
Instance |
String |
The instance of SQL Server. |
IsClustered |
A Boolean value that is true if the instance is participating in failover clustering, or false if it is not. |
|
Version |
String |
The version of the instance of SQL Server. |
IsLocal |
Boolean |
A Boolean value that is true if the instance is local, or false if the instance is remote. |
주의
업데이트된 텍스트:
The computer running the instance SQL Server might not receive responses to the EnumAvailableSqlServers method in a timely manner. The returned list might not show all the available instances of SQL Server on the network. When you call the EnumAvailableSqlServers method in subsequent tries, more servers might become visible on the network.
This method fails to list the local instance if a firewall is operating on the server. The firewall blocks any broadcast traffic issued when the method is called, even if the sender is from local machine.
이 네임스페이스, 클래스 또는 멤버는 Microsoft .NET Framework 2.0 버전에서만 지원됩니다.
예
How to: Register Event Handlers and Subscribe to Event Handling in Visual Basic .NET
스레드 보안
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
SmoApplication Class
SmoApplication Members
Microsoft.SqlServer.Management.Smo Namespace