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 

clear
[appdomain]::CurrentDomain.GetAssemblies()|
Where {$_.FullName -match "SQLServer"}|
Select FullName 

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server