determine MSSQL Service Pack.

u can either use global var @@version
by running
select @@version
-- result:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Standard Edition on Windows NT 5.2 (Build 3790 )

/* While the above global variable containst all needed information, it is hard to interpret it especially if you want to
determine the service pack number,...