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
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.
