SQL Server Setup Discovery Reports & Related Queries


Microsoft Sql Server has given so many options to check which version of SQL installed on server. With this Discovery Report we can check how many instances installed on the server, what is the version, the instance belong to which edition, how many features are enabled for that instance, whether it is clustered or not.

To get discovery report you should have access on server:

GoTo Start >> All Programs >> Microsoft Sql Server ____ (Highest version available on your system) >> Configuration Tools >> SQL Server Installation Center

installation_center  discovery_report

 

Query from Sql Server :

You can also get all above details from sql query-

SELECT
SERVERPROPERTY(‘ServerName’) ‘ServerName’
,@@VERSION ‘Version’
,SERVERPROPERTY(‘Edition’) ‘Edition’
,SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) ‘ComputerNamePhysicalNetBIOS’
,SERVERPROPERTY(‘MachineName’) ‘MachineName’
,SERVERPROPERTY(‘InstanceName’) ‘InstanceName’
,SERVERPROPERTY(‘IsClustered’) ‘IsClustered’
,SERVERPROPERTY(‘IsFullTextInstalled’) ‘IsFullTextInstalled’
,SERVERPROPERTY(‘IsIntegratedSecurityOnly’) ‘IsIntegratedSecurityOnly’
,SERVERPROPERTY(‘IsSingleUser’) ‘IsSingleUser’
,SERVERPROPERTY(‘LCID’) ‘LCID’
,SERVERPROPERTY(‘LicenseType’) ‘LicenseType’
,SERVERPROPERTY(‘ProcessID’) ‘ProcessID’
,SERVERPROPERTY(‘ProductVersion’) ‘ProductVersion’
,SERVERPROPERTY(‘ProductLevel’) ‘ProductLevel’
,SERVERPROPERTY(‘FilestreamShareName’) ‘FilestreamShareName’
,SERVERPROPERTY(‘FilestreamConfiguredLevel’) ‘FilestreamConfiguredLevel’
,SERVERPROPERTY(‘FilestreamEffectiveLevel’) ‘FilestreamEffectiveLevel’