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

This is a prerelease version of SQL-SMO.

Installation Options

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

Install-Module -Name SQL-SMO -AllowPrerelease

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

Install-PSResource -Name SQL-SMO -Prerelease

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

Yevrag35

Copyright

Package Details

Author(s)

Mike Garvey

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)	444	6/22/2019
1.0.0-alpha	17	6/11/2019
0.5.0.0	22,685	11/19/2018
0.4.1.1	116	10/16/2018
0.4.1	21	10/16/2018
0.4.0	185	8/11/2018
0.3.1	316	7/31/2018
0.3.0	17	7/28/2018
0.2.0	172	3/23/2018
0.1.0	24	3/21/2018