Check your SQL Server version and edition


If you are wondering about your SQL Server instance’s version and edition, you can run this query:

SELECT SERVERPROPERTY(‘productversion’) as [Product version], SERVERPROPERTY (‘productlevel’) as [Product level] , SERVERPROPERTY (‘edition’) as Edition

,

@@VERSION as VersionInfo

The query result from my SQL Server 2008 instance is (as today):

product version product level Edition AllInfo
10.0.2531.0 SP1 Developer Edition 

Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (Intel X86)   Mar 29 2009 10:27:29   Copyright (c) 1988-2008 Microsoft Corporation  Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

The version numbers for SQL Server 2005 are:

Product Level Product version
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047
SQL Server 2005 Service Pack 2 2005.90.3042
SQL Server 2005 Service Pack 3 2005.90.4035
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s