How to determine which version of SQL Server 2005 is running

Whenever I raise SR with Genesys, they request for DB Version (exact version) to troubleshoot the problem. Here, I listed one easy way to find SQL Server 2005 version 🙂

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT  SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

The following results are returned:

  • The product version (for example, 9.00.1399.06)
  • The product level (for example, RTM)
  • The edition (for example, Enterprise Edition)