Identify Version Number, Service Pack And Edition For SQL Server 2005

Hello and welcome back!

Today I am going to cover how easily it is to verify the version number, service pack and edition that is installed on SQL Server 2005. When you run the following T-SQL statement it will give you the Product Version, Product Level and the Edition.

Step 1 - Connect to a valid SQL Server 2005 server.

Step 2 - After connecting, open up a query window. It does not matter what database is specified when opening up the query window.

Step 3 - Type and execute the following T-SQL statement:

SELECT SERVERPROPERTY(‘productversion’) AS [Product Version], SERVERPROPERTY (‘productlevel’) AS [Product Level], SERVERPROPERTY (‘edition’) AS [Edition]

This will give you the detailed information you are looking for. If you have another way of identifying this information please post your solution!