How to obtain SQL feature list from the command line

Question

How to obtain SQL feature list from the command line

Sean Perkins

Ten Centuries

Points: 1377
More actions
September 18, 2014 at 12:34 pm

#296565

Is there a command at the CLI or in PowerShell that will list the components installed for SQL? I'm looking for something like the Feature List you can get from running the discovery report from Tools in the SQL Server Installation Center program option.
I'm running SQL Server 2012 on the CORE version of Windows Server 2008 R2 Enterprise. I've searched around the Net, but haven't found anything useful.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sean Perkins Ten Centuries Points: 1377 More actions · Answer 1

Received an answer on another site, wanted to post in case someone else ran into this question.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Sean Perkins (9/25/2014)
Received an answer on another site, wanted to post in case someone else ran into this question.

Making this easier for others:

http://dba.stackexchange.com/questions/77016/how-to-obtain-sql-feature-list-from-the-command-line

Sean Perkins Ten Centuries Points: 1377 More actions · Answer 3

Strange, I used the URL editor and mine didn't make the link like yours is shown 🙁

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

Neil Burton SSC-Insane Points: 23000 More actions · Answer 4

"Enter your text here ""

If you enter the code above without the " you get

This

To just post the link enter it as below

""http://dba.stackexchange.com/questions/77016/how-to-obtain-sql-feature-list-from-the-command-line""

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537