Server property in SQL Server

Below Query will fetch all the information about SQL Server installed in our machine.

Code Snippet

SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered') IsClustered, SERVERPROPERTY('IsFullTextInstalled') IsFullTextInstalled, SERVERPROPERTY('IsIntegratedSecurityOnly') IsIntegratedSecurityOnly, SERVERPROPERTY('IsSingleUser') IsSingleUser, SERVERPROPERTY('IsSyncWithBackup') IsSyncWithBackup, SERVERPROPERTY('LicenseType') LicenseType, SERVERPROPERTY('MachineName') MachineName, SERVERPROPERTY('NumLicenses') NumLicenses, SERVERPROPERTY('ProcessID') ProcessID, SERVERPROPERTY('ProductVersion') ProductVersion, SERVERPROPERTY('ProductLevel') ProductLevel, SERVERPROPERTY('ServerName') ServerName

The output resembles,

select SERVERPROPERTY('Edition') Edition

is an important property used in fetching the edition of our sql server installed in our machine.

Happy Learning!!!

Regards,

Venkatesan Prabu .J