Check the version of SQL Server

I always forget how to check the version and edition of Microsoft SQL Server what is running, so I’ve documented it here.

It’s best to do this from the actual Windows Server running Microsoft SQL Server.

Open a Command Prompt.

Run sqlcmd -s SERVERNAME\INSTANCENAME, for example:

sqlcmd -s X500SERVER1\DEVDB1

In the example above, X500SERVER1 is the SQL Server Name, and DEVDB1 is the SQL Instance Name.

Type:

select @@version

Hit <Enter>.

At the 2> prompt, type:

go

Hit <Enter>.