Tags: Sql Server 2005,SQL Server Errors,SQL Server Basics
@@VERSION doesn't return the SQL Server patch level! It returns the OS/host patch level. Documented at: http://msdn.microsoft.com/en-us/library/ms177512.aspx and http://support.microsoft.com/kb/321185.
@Aasim:- Last line (after ON) returned from @@version is OS information not the SQL server information. @@Version just returns the correct build number.
You can use the build number 9.00.4035.00 and look for the service pack version. Don't know who is maintaining this site, but found this really useful and also updated regularly