• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Dec 112009
 

Sometimes you just get into a twist because of some random SQL issue.  I’m not a SQL guru .. In fact I’m so far from a SQL guru it’s untrue (okay I *am* MCDBA 2000 but I did that without touching the product!)

A few times I’ve had to try and find out what version of SQL I have running.  The easiest way is :-

SELECT serverproperty('ProductVersion')

The meaning of these is :

Version Number Description
8.00.194 SQL Server 2000
8.00.384 SQL Server 2000 Service Pack 1
8.00.532 SQL Server 2000 Service Pack 2
8.00.760 SQL Server 2000 Service Pack 3 (or 3a)
8.00.818 SQL Server 2000 Service Pack 3 with Cumulative Security Patch MS03-031
8.00.2039 SQL Server 2000 Service Pack 4
9.00.1399 SQL Server 2005
9.00.2047 SQL Server 2005 Service Pack 1
9.00.2153 SQL Server 2005 with Rollup for SP1
9.00.3042 SQL Server 2005 Service Pack 2
9.00.3152 SQL Server 2005 with Cumulative Update 1 for SP2
9.00.3175 SQL Server 2005 with Cumulative Update 2 for SP2
9.00.3186 SQL Server 2005 with Cumulative Update 3 for SP2
9.00.3200 SQL Server 2005 with Cumulative Update 4 for SP2
9.00.3215 SQL Server 2005 with Cumulative Update 5 for SP2

You can get other information such as ‘productlevel’ and ‘edition’ which are also sometimes useful.

Hope that helps.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)