SQL-SMO
1.0.0-alpha
A module for gathering and editing SQL Server Instance properties utilizing SQL Management Objects without the need for SQL Management Studio to be installed.
Minimum PowerShell version
4.0
See the version list below for details.
Installation Options
Owners
Copyright
© 2019 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 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 Progress bar find db
Cmdlets
Connect-Server Disconnect-Server Find-SqlInstance Get-Column Get-ServerConfig Get-Server Get-SystemMessages Get-Connection Get-Database Get-DatabaseState Get-AgentJob Get-Table Get-AgentServer Start-AgentJob Set-ServerConfig Set-AgentJob Set-AgentServer Stop-AgentJob
Dependencies
This module has no dependencies.
FileList
- SQL-SMO.nuspec
- AgentJob.ps1xml
- AgentServer.ps1xml
- MG.Dynamic.dll
- MG.Progress.PowerShell.dll
- MG.Sql.Smo.dll
- MG.Sql.Smo.PowerShell.dll
- Microsoft.ActiveDirectory.Management.dll
- Microsoft.SqlServer.ConnectionInfo.dll
- Microsoft.SqlServer.Diagnostics.STrace.dll
- Microsoft.SqlServer.Dmf.Common.dll
- Microsoft.SqlServer.Management.Sdk.Sfc.dll
- Microsoft.SqlServer.ServiceBrokerEnum.dll
- Microsoft.SqlServer.Smo.dll
- Microsoft.SqlServer.SqlClrProvider.dll
- Microsoft.SqlServer.SqlEnum.dll
- SmoColumn.ps1xml
- SmoConfiguration.ps1xml
- SmoServer.ps1xml
- SmoTable.ps1xml
- SQL-SMO.psd1
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 1.0.0-beta | 620 | 6/22/2019 |
| 1.0.0-alpha (current version) | 21 | 6/11/2019 |
| 0.5.0.0 | 24,369 | 11/19/2018 |
| 0.4.1.1 | 118 | 10/16/2018 |
| 0.4.1 | 25 | 10/16/2018 |
| 0.4.0 | 187 | 8/11/2018 |
| 0.3.1 | 384 | 7/31/2018 |
| 0.3.0 | 18 | 7/28/2018 |
| 0.2.0 | 173 | 3/23/2018 |
| 0.1.0 | 25 | 3/21/2018 |