How to check your SQL Server Version?

If you come across some strange differences in your SQL Server or SQL Management Studio in comparisons to what others are using, you are sure to be tempted to want to check you version number to make sure if you have the latest version with all the latest Service Packs Installed.

Here this table should help you to understand which version you have.
The following table lists the Sqlservr.exe version number.

Release
Sqlservr.exe
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
 
Just Goto Help Menu in your SQL Management Studio and select the About menu item and it should come with a window and it should have the version information. You can compare that version numbers with the above table to know if you have the right version required and if the latest Service Pack is installed.
For more information on Identifying your SQL Server Version and Edition, read this How to Identify your SQL Server version and Edition
Also you can download SQL Server 2005 Service Packs from here:
 
SQL Server 2008 Service Packs
 
References: