How to find out your SQL Server version?

Here’s a quick trick the will allow you to easily retrieve information about the Microsoft SQL Server version that you are currently running. This quick how-to was written using SQL Server 2005, but it’s applicable to SQL Server 2000 as well.

1. Login to the Microsoft SQL Server Management Studio (Query Analyzer in SQL Server 2000)
2. Click New Query
3. Type and Execute the following SQL command:

SELECT SERVERPROPERTY (‘productlevel’) as ‘Product Level’, SERVERPROPERTY(‘productversion’) as ‘Product Version’, SERVERPROPERTY (‘edition’) as ‘SQL Server Edition’

A complete map of SQL Server product Level and Product Versions can be found at the bottom of this page.