Server.Information Property
Gets information about the instance of Microsoft SQL Server.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
语法
声明
Public ReadOnly Property Information As Information
public Information Information { get; }
public:
property Information^ Information {
Information^ get ();
}
/** @property */
public Information get_Information ()
public function get Information () : Information
属性值
An Information object that specifies information about the instance of SQL Server.
备注
已更新的文本:
The Information property points to the Information object that stores read-only information about the SQL Server installation. This includes information about the operating system, the version of the product, and the physical location of the installation.
仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。
示例
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display information about the instance of SQL Server in Information and Settings.
Console.WriteLine("OS Version = " & srv.Information.OSVersion)
Console.WriteLine("State = " & srv.Settings.State.ToString)
'Display information specific to the current user in UserOptions.
Console.WriteLine("Quoted Identifier support = " & srv.UserOptions.QuotedIdentifier)
'Modify server settings in Settings.
srv.Settings.LoginMode = ServerLoginMode.Integrated
'Modify settings specific to the current connection in UserOptions.
srv.UserOptions.AbortOnArithmeticErrors = True
'Run the Alter method to make the changes on the instance of SQL Server.
srv.Alter()
线程安全
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: Copy an SMO Object in Visual Basic .NET
Configuring SQL Server (SMO)
管理服务器