SQL-SMO
1.0.0-beta
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
Installation Options
Owners
Copyright
(c) 2019 Yevrag35, 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
Get-Column Connect-Server Disconnect-Server Find-SqlInstance Get-Credential New-Credential Get-Database New-Database Remove-Database Set-DatabaseState Get-JobCategory New-JobCategory Remove-JobCategory Set-JobCategory Get-Job Remove-Job Set-Job Start-Job Stop-Job Get-JobServer Set-JobServer Get-JobStep Get-Login New-SqlLogin New-WindowsLogin Remove-Login Rename-Login Set-Login Set-LoginPassword Get-DatabaseLog Get-Process Stop-Process Out-SqlScript Write-SqlScript Get-Server Get-ServerCollation Get-ServerConfig Get-ServerErrorLog Get-SystemMessages Get-UserDefinedMessages Set-ServerConfig Get-Table Add-DbUser Get-DbUser Remove-DbUser Get-View
Dependencies
This module has no dependencies.
FileList
- SQL-SMO.nuspec
- AgentServer.ps1xml
- MG.Dynamic.dll
- MG.Progress.PowerShell.dll
- MG.Sql.Smo.dll
- MG.Sql.Smo.PowerShell.dll
- MG.Swappable.Dictionary.dll
- Microsoft.ActiveDirectory.Management.dll
- Microsoft.Management.Infrastructure.dll
- Microsoft.PowerShell.LocalAccounts.dll
- Microsoft.PowerShell.LocalAccounts.Resources.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
- SmoCredential.ps1xml
- SmoDatabase.ps1xml
- SmoJob.ps1xml
- SmoJobCategory.ps1xml
- SmoJobStep.ps1xml
- SmoLogFile.ps1xml
- SmoLogin.ps1xml
- SmoServer.ps1xml
- SmoSqlProcess.ps1xml
- SmoTable.ps1xml
- SmoUser.ps1xml
- SQL-SMO.psd1
Version History
Version | Downloads | Last updated |
---|---|---|
1.0.0-beta (current version) | 538 | 6/22/2019 |
1.0.0-alpha | 21 | 6/11/2019 |
0.5.0.0 | 24,161 | 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 | 351 | 7/31/2018 |
0.3.0 | 18 | 7/28/2018 |
0.2.0 | 173 | 3/23/2018 |
0.1.0 | 25 | 3/21/2018 |