October 27, 2016 at 3:31 pm
Is there a query to get a list of db features
I tried using SQL server central and then tools and then report but it says incompatible, I need another way of getting them
October 27, 2016 at 6:38 pm
sqlserverDBA2016 (10/27/2016)
Is there a query to get a list of db featuresI tried using SQL server central and then tools and then report but it says incompatible, I need another way of getting them
That's a pretty broad question. What do you mean by "db features" you want to list?
October 27, 2016 at 6:45 pm
Sorry I ment list of instance features
October 27, 2016 at 10:24 pm
Im talking about the features like ssas , ssrs , ssis and full text search and client management tools etc...
is there qquery to run to retrieve that.
October 28, 2016 at 4:27 am
I think your question is answered by this thread on dba.stackexchange.com:
http://dba.stackexchange.com/questions/77016/how-to-obtain-sql-feature-list-from-the-command-line
October 29, 2016 at 4:52 pm
Sorry but there's only one command there : get services sql
Without any explanation on where or how to run it, is it on cmd or where
October 29, 2016 at 10:11 pm
sqlserverDBA2016 (10/29/2016)
Sorry but there's only one command there : get services sqlWithout any explanation on where or how to run it, is it on cmd or where
The answer you're referring to reads:
You can get the server level components by using a PowerShell command like:
Get-Service *SQL*
Hence, it would be run from PowerShell
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2016 at 5:23 am
sqlserverDBA2016 (10/29/2016)
Sorry but there's only one command there : get services sqlWithout any explanation on where or how to run it, is it on cmd or where
If you read the answer carefully they provide two commands; one for services and one for installed components. As copied from stackexchange (with bold emphasis by me):
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
share
improve this answer
edited Sep 18 '14 at 19:39
answered Sep 18 '14 at 19:33
Shawn Melton
11.7k22866
1
Had something similar recently, have a look at this: dba.stackexchange.com/questions/76230/… – wBob Sep 18 '14 at 23:40
That is exactly what I was looking for Shawn! Also, thanks for the redirect wBob. – Sean Perkins Sep 24 '14 at 21:10
October 30, 2016 at 5:31 am
I'm not an expert in powershell that's why I was asking
Is there any other way beside pow
ershell
October 30, 2016 at 6:36 am
sqlserverDBA2016 (10/30/2016)
I'm not an expert in powershell that's why I was askingIs there any other way beside pow
ershell
It can't be done directly from T-SQL, so you'll need an external tool anyway.
To execute the PowerShell commands:
- open a command prompt
- type "powershell" + enter
- copy/paste the command(s) from the previous posts
For an administrator on the Windows platform it is advisable to start learning and using PowerShell. Knowing at least the basics will enhance your level of expertise and will improve the capabilities to finish your tasks and solve your problems quicker.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply