Thanks for the info.
>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).