Get‑SqlDscStartupParameter

SYNOPSIS

Get current startup parameters on a Database Engine instance.

SYNTAX

ByServerName (Default)

Get-SqlDscStartupParameter [-ServerName <String>] [-InstanceName <String>] 
 [<CommonParameters>]

ByServiceObject

Get-SqlDscStartupParameter -ServiceObject <Service> [<CommonParameters>]

DESCRIPTION

Get current startup parameters on a Database Engine instance.

EXAMPLES

EXAMPLE 1

Get-SqlDscStartupParameter

Get the startup parameters from the Database Engine default instance on the server where the command in run.

EXAMPLE 2

$serviceObject = Get-SqlDscManagedComputerService -ServiceType 'DatabaseEngine'
Get-SqlDscStartupParameter -ServiceObject $serviceObject

Get the startup parameters from the Database Engine default instance on the server where the command in run.

EXAMPLE 3

Get-SqlDscStartupParameter -InstanceName 'SQL2022'

Get the startup parameters from the Database Engine instance 'SQL2022' on the server where the command in run.

EXAMPLE 4

$serviceObject = Get-SqlDscManagedComputerService -ServiceType 'DatabaseEngine' -InstanceName 'SQL2022'
Get-SqlDscStartupParameter -ServiceObject $serviceObject

Get the startup parameters from the Database Engine instance 'SQL2022' on the server where the command in run.

PARAMETERS

-InstanceName

Specifies the instance name to return the trace flags for.

Type: String
Parameter Sets: ByServerName
Aliases:

Required: False
Position: Named
Default value: MSSQLSERVER
Accept pipeline input: False
Accept wildcard characters: False

-ServerName

Specifies the server name to return the trace flags from.

Type: String
Parameter Sets: ByServerName
Aliases:

Required: False
Position: Named
Default value: (Get-ComputerName)
Accept pipeline input: False
Accept wildcard characters: False

-ServiceObject

Specifies the Service object to return the trace flags from.

Type: Service
Parameter Sets: ByServiceObject
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

[StartupParameters]

NOTES

RELATED LINKS