通过

Server.GetPropertyNames Method

  • 项目

Returns the names of the initialized properties for the specified object type

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Function GetPropertyNames ( _
    typeObject As Type _
) As StringCollection

public StringCollection GetPropertyNames (
    Type typeObject
)

public:
StringCollection^ GetPropertyNames (
    Type^ typeObject
)

public StringCollection GetPropertyNames (
    Type typeObject
)

public function GetPropertyNames (
    typeObject : Type
) : StringCollection

参数

  • typeObject
    A Type system object that specifies the type of object.

返回值

A StringCollection system object that contains a list property names for the specified object.

备注

已更新的文本：

SMO optimization allows only the minimum properties to be loaded when an object is created. You can use this method to see which properties are currently initialized for an object at any point in your application.

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display all the loaded properties for the Server type.
Dim s As String
Console.WriteLine("===Before State property is accessed.===")
For Each s In srv.GetPropertyNames(srv.GetType)
    Console.WriteLine(s.ToString)
Next
'Access the State property of the Server object.
Console.WriteLine(srv.State)
'Again, display the loaded properties for the Server type.
Console.WriteLine("===After State property is accessed.===")
    For Each s In srv.GetPropertyNames(srv.GetType)
    Console.WriteLine(s.ToString)
Next

线程安全

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 的硬件和软件要求。

请参阅

参考

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

其他资源

How to: Set Default Initialization Fields in Visual Basic .NET
Calling Methods
管理服务器