The estimated reading time for this post is 0 minutes

This one’s quick. There are a couple of ways to find out your SQL server version. Firstly the version is listed within the Object Explorer in the Microsoft SQL Server Management Studio. The second option which provides more detailed information is to run the following query.

select @@version

The version information is returned in the query results section at the bottom. Both examples of obtaining the SQL server version are shown in the image below.