How to find the service pack version installed on SQL Server using @@version (Info on SQL Server service packs and versions): Narayana Vyas Kondreddi's home page: "SQL Server Version Table:

No SP
(RTM or Golden) SP1 SP2 SP3 / SP3a SP4 SP5 SP5a
SQL Server 6.0 6.00.121 6.00.124 6.00.139 6.00.151
SQL Server 6.5
(Hydra) 6.50.201 6.50.213 6.50.240 6.50.258 6.50.281 6.50.415 6.50.416
SQL Server 7.0
(Sphinx) 7.00.623 7.00.699 7.00.842 7.00.961 7.00.1063
SQL Server 2000
(Shiloh) 8.00.194 8.00.384 8.00.534 8.00.760 8.00.2039
SQL Server 2005
(Yukon) 9.00.1399.06

Apart from SELECT @@VERSION, there are other commands too, that show you the build number. Try, sp_server_info and master..xp_msver. In SQL Server 2000, there is a new system function called SERVERPROPERTY, that returns service pack information. Here is an example:

SELECT SERVERPROPERTY('ProductLevel')
GO
For VB code to find out the version and service pack information of SQL Server, click here

Microsoft recently came up with a KB article on this topic:

Q321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition

Click here to download SQL Server service packs, tools, add-ins, sample code, updates etc."