Server.Information Server.Information Server.Information Property

Definition

Gets information about the instance of SQL Server.

public:
 property Microsoft::SqlServer::Management::Smo::Information ^ Information { Microsoft::SqlServer::Management::Smo::Information ^ get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObject(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObjectRelationship.ChildObject, Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObjectCardinality.One)]
public Microsoft.SqlServer.Management.Smo.Information Information { get; }
Public ReadOnly Property Information As Information
Property Value

An Information object that specifies information about the instance of SQL Server.

Examples

Visual Basic

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")  
Write-Host "OS Version =" $srv.Information.OSVersion  
Write-Host "State =" $srv.Settings.State.ToString()  
Write-Host "Quoted Identifier support =" $srv.UserOptions.QuotedIdentifier  
$srv.Settings.LoginMode = [Microsoft.SqlServer.Management.Smo.ServerLoginMode]::Integrated  
$srv.UserOptions.AbortOnArithmeticErrors = $TRUE  
$srv.Alter()  

Remarks

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.

Applies to