how to list all features installed in a sql server instance?

Question

There are other Installation related questions with similar details here and here.

I could not find anything related to listing the installed features in sql server 2016 though.

I can do it manually looking at the logs - as per the info below, but I would like to automate it.

After installing SQL Server 2016 I get a log file - located somewhere in these folders:

C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20200109_205540

A file which the name starts with Summary_ +my_server_name

in that file, amongst other things I can find a list of the Sql Server Features installed:

After installation, later on when the systems are already in use, logins and permissions applied, firewall fixed, etc.

Is there a simple way to get hold of the list of features installed on a sql server instance?

Piotr Palka · Accepted Answer · 2020-01-10 20:23:15Z

6

You can run "Installed SQL Server features discovery report"

answered Jan 10, 2020 at 20:23

Piotr Palka

1,5719 silver badges15 bronze badges

1

I doubt if this report give the level of details @Marcello is looking for.
– SqlWorldWide
Jan 10, 2020 at 20:29

Add a comment |

Robert Rubinberg · Accepted Answer · 2020-01-10 20:44:08Z

3

Check out the Query written by Pawan:

answered Jan 10, 2020 at 20:44

Robert Rubinberg

775 bronze badges

The TSQL query in the link doesn't tell if replication is enabled or not.
– RaviLobo
Apr 18 at 1:43

Add a comment |

2 Answers 2