What Version of SQL Server Is Running?

Question

Apologies for this basic question. Could someone advise how I establish definitively what version of SQL Server or SQL Server Express is running and whether or not it is Server or Server Express?

Thanks in advance

Answer 1

Hi,

Basically you can use serverproperty function to get this detail , You can use the below query in SSMS

1. SELECT SERVERPROPERTY ('edition') as SQLEDITION
To get further more details about the server,
2. SELECT SERVERPROPERTY('productversion') as VERSION, SERVERPROPERTY ('productlevel') as SERVICEPACK,
SERVERPROPERTY ('edition') as SQLEDITION , SERVERPROPERTY ('ServerName') as SERVERNAME

---

Thanks, Leks

Answer 2

Without logging in to SQL server , you can read the info from registry , HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup and see the EDITION value from this key .

---

Thanks, Leks

Answer 3

Hi,

Run this Query

SELECT @@Version

---

Rajesh Jonnalagadda http://www.ggktech.com

Answer 4

Leks / Rajesh,

Thank you for your feedback. Hopefully this will help me get to the bottom of an issue relating to updating the SQL software, if not I will post another query on the forums.

Many thanks again.