TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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)

public:
[SfcObjectAttribute(SfcObjectRelationship::ChildObject, SfcObjectCardinality::One)]
property Information^ Information {
	Information^ get();
}

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

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()

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

Return to top
Show:
© 2016 Microsoft