PowerTip: Use PowerShell to Find Versions of SQL Server

Summary: Use Windows PowerShell to find versions of SQL Server.

 How can I use Windows PowerShell to see all the versions of SQL Server I have installed?

 Use the provider and a list of instances to look them up as if they were files in a directory:

$instances = @(‘KIRK’,’SPOCK’,’PICARD’,’RIKER’)

$instances | ForEach-Object {Get-Item “SQLSERVER:\SQL\$_\DEFAULT”} | Select-Object Name,VersionString