SQL Server Setup Discovery Reports & Related Queries

0

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’

I am Microsoft Certified Professional for querying & Administering Sql Server. I believe “The greatest barrier to success is the fear of failure.”
I am also available at http://dbavimal.blogspot.com

%d bloggers like this: