Identifying SQL Server Version and edition

One of the most useful statements for a SQL Server DBA is also probably one of the easiest…

select @@version;

See below for output on my laptop running windows xp, while connected to SQL Server 2005 RTM

Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

This query is getting its detail from the system stored procedure xp_msver which can be called like so:

exec master..xp_msver

If you prefer a more user friendly broken down version of the above then you can run:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
9.00.1399.06 RTM Developer Edition

Microsoft provide a useful page for finding the version and edition and details all the different versions with SPs which can be found Here.

If you want more detail on each cumulative update then check out the SQL Team version page

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

%d bloggers like this: