SQL SERVER – How To Find Out which Version of Microsoft SQL Server is running

Some times we have to find out the Version of SQL Server that is running.

There are many ways to find out the version of the SQL Server.

In Order to find out  the version of Microsoft SQL Server, First Of all connect to SQL Server by using SQL Server Management Studio, and then run the following Transact-SQL statement.

Select @@version  'Version'

This Results,

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

OutPut :

The Other Alternative is, using the system stored Procedure Sp_msgetversion

 Exec master..sp_msgetversion

OutPut :

As a third alternative, we can use the Extended stored procedure xp_msver. This Command gives a detailed information like ProductName, ProductVersion, Language etc.,

OutPut :