SQL-SMO

0.3.1

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

Next release will include source code.  Feel free to throw suggestions in the comments.

Currently working on:
Get-SMODatabase
Get-SMOTable
Get-SMOColumn

Minimum PowerShell version

3.0

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

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name SQL-SMO -Version 0.3.1

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

Owners

Copyright

© 2018 DGR Systems, LLC. All rights reserved.

Package Details

Author(s)

  • Mike Garvey

Tags

SQL Server Instance Property Setting Settings Set Change SMO Management Object Memory Max Min MB Megabyte Subproperty Feature Microsoft New Value Configuration Alter Authentication Credential Integrated Security Documenting default connection string data context format

Cmdlets

Disconnect-SMO New-SMO Set-SMOContext Get-SQLMemoryLimits

Functions

Get-SMOConfiguration Set-SMOConfiguration Set-SQLMemoryLimit

Dependencies

This module has no dependencies.

Release Notes

Added "Disconnect-SMO", which also frees up memory if the SMO context was enumerated.

FileList

  • SQL-SMO.nuspec
  • SQL-SMO.psd1
  • SQL-SMO.psm1
  • Assemblies\DynamicParameter.dll
  • Assemblies\Microsoft.SqlServer.ConnectionInfo.dll
  • Assemblies\Microsoft.SqlServer.Diagnostics.STrace.dll
  • Assemblies\Microsoft.SqlServer.Dmf.Common.dll
  • Assemblies\Microsoft.SqlServer.Management.Sdk.Sfc.dll
  • Assemblies\Microsoft.SqlServer.ServiceBrokerEnum.dll
  • Assemblies\Microsoft.SqlServer.Smo.dll
  • Assemblies\Microsoft.SqlServer.SqlClrProvider.dll
  • Assemblies\Microsoft.SqlServer.SqlEnum.dll
  • Assemblies\SQL.SMO.dll
  • Formats\SQL.SMO.MemoryProperty.Format.ps1xml
  • Formats\SQL.SMO.SMOProperty.Format.ps1xml

Version History

Version Downloads Last updated
1.0.0-beta 548 6/22/2019
1.0.0-alpha 21 6/11/2019
0.5.0.0 24,183 11/19/2018
0.4.1.1 118 10/16/2018
0.4.1 22 10/16/2018
0.4.0 187 8/11/2018
0.3.1 (current version) 356 7/31/2018
0.3.0 18 7/28/2018
0.2.0 173 3/23/2018
0.1.0 25 3/21/2018
Show less