Server.Information Property


Gets information about the instance of SQL Server.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)>
Public ReadOnly Property Information As Information

Property Value

Type: Microsoft.SqlServer.Management.Smo.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.

Visual Basic


$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

Server Class
Microsoft.SqlServer.Management.Smo Namespace
Configuring SQL Server (SMO)
Managing Servers

Return to top