How to get SQL Server Version and Edition related info?

On 16 Apr, 2015

MS SQL DBA

By : Charith Silva

No Comments

SQL Server instance information can be retrieved in number of different ways. Following T-SQL statement retrieves information such as Hostname, instance name, Server Edition (32 bit or 64 bit), ServicePack and cluster configuration from current SQL Server instance.

SELECT
@@ServerName AS Server ,
SERVERPROPERTY('MachineName') as Host,
SERVERPROPERTY('InstanceName') as Instance,
SERVERPROPERTY('Edition') as Edition,
SERVERPROPERTY('ProductLevel') as ProductLevel,
Case SERVERPROPERTY('IsClustered') when 1 then 'CLUSTERED' else 'STANDALONE' end as ServerType,
@@VERSION as VersionNumber

SELECT

@@ServerName AS Server ,

SERVERPROPERTY('MachineName') as Host,

SERVERPROPERTY('InstanceName') as Instance,

SERVERPROPERTY('Edition') as Edition,

SERVERPROPERTY('ProductLevel') as ProductLevel,

Case SERVERPROPERTY('IsClustered') when 1 then 'CLUSTERED' else 'STANDALONE' end as ServerType,

@@VERSION as VersionNumber

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva