Determine SQLServer version via query

by Gregor Uhlenheuer on October 15, 2011

The very simple way to find out the version of your SQL Server that is currently in use is:

The disadvantage of this command is that the whole version string is returned from this query. In order to get more fine grained information about your SQL Server you will want to use SERVERPROPERTY instead:

You can find further information about the SQL Server versions right here:

This post is tagged with tsql, sql and sqlserver