Monthly Archives: October 2020


LoadWithPartialName [reflection.assembly]::loadwithpartialname(“Microsoft.SqlServer.Smo”) | out-null pipe with out-null to avoid output. New-Object $srv = New-Object (‘Microsoft.SqlServer.Management.Smo.Server’) pipe with gm (get member) sidebar: $a = dir $a will display directory now if we do $a | gm it will have properties for directory. Like move to, Extension, Encrypted etc. $srv = New-Object […]

SQL Server SMO in PowerShell