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
Rajkishore Sahoo is a Microsoft Azure consultant with more than 14 years of hands-on experience building cloud-native data solutions across Azure and AWS, focused on Azure SQL Database, Azure SQL Managed Instance, and the pipelines that connect them to production apps. Day to day, he provisions Azure SQL instances, configures firewalls and connection strings, tunes queries for cloud workloads, and wires databases into Azure Functions and Logic Apps. Read more