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)