Get-SqlEdition

Returns a custom object with the Server name and Edition.

Syntax

Get-SqlEdition [-sqlserver] <Object> [<CommonParameters>]

Detailed Description

The Get-SqlEdition function returns a custom object with the Server name and Edition for the specified SQL server.

Related Commands

* Get-SqlEdition

Parameters

Name Description Required? Pipeline Input Default Value
sqlserver    true  false   

Input Type

None You cannot pipe objects to Get-SqlEdition

Return Values

Selected.Microsoft.SqlServer.Management.Smo.Information Get-SqlEdition returns a Selected.Microsoft.SqlServer.Management.Smo.Information object.

Examples

EXAMPLE 1

Get-SqlEdition "Z002\sql2k8"
This command returns SQL Edition information for the Z002\sql2k8 SQL Server.