Until SQL Server 2005 SP3 I used to remember the version from the build number of SQL Server, however since 2008 version it was hard to remember due to the fact of cumulative update package releases.
Since the changes affected from SQL Server Release Services and inception of Cumulative Update packages it is hard to keep a track of list of builds and version releases. Let it be a controlled installation of service packs and cumulative update packages, you must know the information in order to check what is fixed in the release.In general the best practice is to apply only service pack releases patch to the active instances of SQL in your data platform, but it is essential as a DBA to keep a track of cumulative update package releases.
The incremental changes and naming convention of each cumulative package is required to understand whether it is important for your environment or not. For the ogransiations where they do not have a ‘DBA’ then its better to follow few links down in the blog to ensure they are following best practices (at the least)!!
The first and foremost helpful is:
then you must obtain the information
- software update terminology that is used to describe the software updates.
Coming back to keeping a track of build version and cumulative update package releases along with service pack versions, look at the SQL Server version database link which is my favourite and always follow to keep up the release information.
Also you can keep a track by referring to MSDN blog SQL Server history & sqlserverbuilds.blogspot.com/ blogs too which highlights the fixes that are required. However the information from SQL Server version database is much broader than these 2 links which will go back to stone-age versions of SQL Server too.
Finally you can also run the piece of code below to obtain the necessary information for your existing SQL instance:
CAST(SERVERPROPERTY(‘Edition’) as nvarchar(128)) [Edition],
CAST(SERVERPROPERTY(‘ProductVersion’) as nvarchar(128)) [Build Number],
CAST(SERVERPROPERTY(‘ProductLevel’) as nvarchar(128)) [Service Pack level]
Further if you have a server