Beware of using @@version with SQL 2000. While it works on SQL 2000, and it does display a service pack level, it is displaying the service pack level of the OS and not SQL server. You had to use @@version on SQL 7. SQL 2000 uses the following:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

This will actually return the service pack of SQL Server (productlevel).