How get information about local server in SQL Server 2012?
Sometimes we must get information about our server. How to do it? I write about it in this post.
There are several configuration functions stored these information. First is @@SERVERNAME stored name of local server. It will be name of your computer.
SELECT @@SERVERNAME ;
Another is @@SERVICENAME return name of your SQL Server.
SELECT @@SERVICENAME ;
The @@VERSION return version your SQL Server.
SELECT @@VERSION ;
If You would like info about language in SQL Server, apply @@LANGUAGE function.
SELECT @@LANGUAGE ;
Another way to get these information is to apply metadata function: SERVERPROPERTY. This function get one argument – name of property. Property Edition inform about edition your local server.
SELECT SERVERPROPERTY ( 'Edition' )
Property EngineEdition return more number of edition server.
SELECT SERVERPROPERTY ( 'EngineEdition' )
It is list of meaning this numbers:
1 = Personal or Desktop Engine (Not available in SQL Server 2005 and later versions.) 2 = Standard (This is returned for Standard, Web, and Business Intelligence.) 3 = Enterprise (This is returned for Evaluation, Developer, and both Enterprise editions.) 4 = Express (This is returned for Express, Express with Tools and Express with Advanced Services) 5 = SQL Database 6 - SQL Data Warehouse
Property InstanceName return name of instance SQL Server but for default instance return NULL.
SELECT SERVERPROPERTY ( 'InstanceName' )
MachineName or ServerName are properties for name of your computer with SQL Server. It is the same as @@SERVERNAME configuration function.
SELECT SERVERPROPERTY ( 'MachineName' )
If You would like to get level and version SQL Server, htese information give You ProductVersion and ProductLevel properties.
SELECT SERVERPROPERTY ( 'ProductVersion' ) as ProductVersion, SERVERPROPERTY ( 'ProductLevel' ) as ProductLevel ;