SQL Management Objects(SMO) of SQL Server in Powershell and also finding out Server Management Objects
Import-Module SQLPS
-DisableNameChecking
$MyComputer=$env:COMPUTERNAME
#Provide sql server instance name here
$instanceName=$MyComputer+'\TEST'
$instanceName
#This information will give you all SMO'S of SQL Server
$server=New-Object `
-TypeName Microsoft.SQLServer.Management.Smo.Server
`
-ArgumentList $instanceName
$server|
Get-Member -MemberType
"Property"|
Where-Object Definition
-like "*SMO*"
The below Powershell query will provide us the information about SQL Server Assemblies
The below Powershell query will provide us the information about SQL Server Assemblies
clear
[appdomain]::CurrentDomain.GetAssemblies()|
Where {$_.FullName -match
"SQLServer"}|
Select FullName
Comments