SpConfig

Export-DbaSpConfigure

Chrissy LeMaire (@cl), netnerds.net

Export-DbaSpConfigure View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Generates SQL script containing all sp_configure settings for SQL Server instance configuration replication and documentation. Description Creates a complete SQL script file with EXEC sp_configure statements for all server configuration options, including advanced settings. This script can be executed on another SQL Server instance to replicate the exact same configuration settings, making it invaluable for environment standardization, disaster recovery preparation, or compliance documentation.

Get-DbaSpConfigure

Nic Cain, sirsql.net

Get-DbaSpConfigure View Source Nic Cain, sirsql.net Windows, Linux, macOS Synopsis Retrieves SQL Server sp_configure settings with default value comparisons for configuration auditing Description Retrieves all SQL Server instance-level configuration settings accessible through sp_configure, using SMO to gather comprehensive details about each setting. This function compares current configured and running values against SQL Server defaults to quickly identify which settings have been customized from their out-of-box values. Essential for configuration auditing, compliance checks, and ensuring consistency across multiple SQL Server environments.

Import-DbaSpConfigure

Chrissy LeMaire (@cl), netnerds.net

Import-DbaSpConfigure View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Copies sp_configure settings between SQL Server instances or applies settings from a SQL file. Description Copies all sp_configure settings from a source SQL Server instance to a destination instance, or applies sp_configure settings from a SQL file to an instance. This function handles advanced options visibility, validates server versions for compatibility, and executes the necessary RECONFIGURE statements. Essential for maintaining consistent configuration across environments during migrations, standardization projects, or when applying saved configuration templates.