The components for SQL Server 2012 are divided by server and then management tools. You can get the server level components by using a PowerShell command like:
Get - Service * SQL
To get the management tools would require either registry search for the uninstall list or you can query the WMI class win32_product:
get - wmiobject win32_product | WHERE {$_.NAME - match "SQL" - AND $_. vendor - eq "Microsoft Corporation" } | SELECT NAME ,version
Reference: http://dba.stackexchange.com/questions/77016/how-to-obtain-sql-feature-list-from-the-command-line
No comments:
Post a Comment