A module for gathering and editing SQL Server Instance properties utilizing SQL Management Objects.  *No SSMS Install necessary!*

Minimum PowerShell version


There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SQL-SMO -RequiredVersion 0.4.0

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More


Mike Garvey


© 2018 DGR Systems, LLC. All rights reserved.

Package Details



SQL Server Instance Property Setting Settings Set Change SMO Management Object Memory Tables Columns Max Min MB Megabyte Feature Microsoft New Value Configuration Alter Authentication Connection Get RAM Credential Integrated Security Documenting default string data context format Database Query


Get-SMOConfiguration Disconnect-SMO New-SMO Set-SMOContext Get-SQLMemoryLimit Get-SMOConnection Set-SQLMemoryLimit Set-SMOConfiguration Get-SMODatabase Get-SMOColumn Get-SMOTable


This module has no dependencies.

Release Notes

All commands moved to C#.  The source code is now included.  New commands are being introduced: "Get-SMODatabase, Get-SMOTable, & Get-SMOColumn"!  As with Get-SMOConfiguration, Get-SMODatabase will dynamically pull the list of databases.


Version History

Version Downloads Last updated
1.0.0-beta 131 6/22/2019
1.0.0-alpha 14 6/11/2019 18,272 11/19/2018 114 10/16/2018
0.4.1 18 10/16/2018
0.4.0 (current version) 149 8/11/2018
0.3.1 253 7/31/2018
0.3.0 15 7/28/2018
0.2.0 170 3/23/2018
0.1.0 22 3/21/2018
Show less