Listing 1. Code That Checks the Service Pack Version

DECLARE @ProductVersion varchar(32)
SELECT @ProductVersion = cast(SERVERPROPERTY
  ('ProductVersion') as varchar(32))
IF @ProductVersion >= '8.00.2039'
 PRINT 'PASS'