| More

Recent News » SQL

List SQL Server Instances using Powershell and Get-ItemProperty

Posted by: SQL Server DBA, on 04 Feb 2012 | View original | Bookmarked: 0 time(s)

This post explains how to list SQL Server Instances installed on the current server, using the Powershell Get-ItemProperty Cmdlet.The Get-ItemProperty Cmdlet gets the properties of a specific item.In this example, the command displays the Name and Data from the registry entries in the SQL registry subkey.Notice the Powershell drive : HKLM. Its mapped to the HKEY_LOCAL_MACHINE .Get-ItemProperty 'HKLM:\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL' See AlsoSQL Server Send email using...

Advertisement

Free Agile Project Management Tool from Telerik TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 300 | Hits: 12

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD