Vikram Kamath

August 9, 2011

SQL Server Version and Build Number

Filed under: SQL Server — Tags: , , , — Vikram @ 15:59

I try to link various SQL Server versions (RTM, Service Packs, Cumulative Updates) with respective build numbers. Here are a few links that I use which might come in handy for many of you database developers out there. Some of these links are official and some aren’t.

  1. How to determine the version and edition of SQL server and its components
  2. SQL Server Version
  3. SQL Server Version Database
  4. sqlserverbuilds.blogspot.com

Some of the above links are comprehensive enough for most developers.

Some useful SQL Server functions to determine the version and edition:

@@VERSION
SERVERPROPERTY('productversion')
SERVERPROPERTY('productlevel')
SERVERPROPERTY('edition')
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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

Blog at WordPress.com.

%d bloggers like this: