As an SQL server developer, it is pretty essential for you to know what SQL server edition you are using?. In this article Let us discuss all the approaches to check SQL Server edition.
How To Check SQL Server Edition
We will discuss all the possible approaches to check the edition of your SQL server.
Approach-1 Using SQL Server Management studio (SSMS)
To check SQL Server edition, follow the below steps.
1. Open SQL Server Management Studio (SSMS) and connect to your SQL server instance.
2. Right-click on the Object Explorer and select the Properties option as shown below.
3. On the General tab, check the Product level, where you will see the edition. For me, it is Express (64-bit) edition.
Approach-2 SQL Query
We can also use the below query to find SQL server edition.
SELECT @@VERSION AS SQLServerVersion,
SERVERPROPERTY('Edition') AS EditionAfter executing the above query, I got the expected output as shown below. Now, you can see for me, the edition is Express Edition (64-bit).
Video Tutorial
Conclusion
We discussed here, how to find SQL server edition. Now, we can use of any of the approach mentioned in this article to achieve this.
You may also like following the articles below.
- Cannot find type [microsoft.sqlserver.management.smo.server]
- How To See What Version Of SQL Server Is Running
Shivam Dogra is a cloud database developer and Team Lead at TSInfo Technologies, where he has worked since June 2021. He writes the SQL Server and Oracle tutorials on DatabaseFAQs.com, covering queries, joins, stored procedures, triggers and permissions. Shivam holds a Master of Computer Applications (MCA) from Chandigarh University.