Get‑SqlDscStartupParameter - dsccommunity/SqlServerDsc GitHub Wiki

Get current startup parameters on a Database Engine instance.

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

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

Get current startup parameters on a Database Engine instance.

Get-SqlDscStartupParameter

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

$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.

Get-SqlDscStartupParameter -InstanceName 'SQL2022'

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

$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.

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

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

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

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