Verify service pack

[Maii]

hi there,
Is there any way to verify which service pack installed in SQL 2000 server?
thanks in advance
maii

 

[dbomrrsm]

Few Ways

CREATE FUNCTION ServicePackversion ()
RETURNS varchar(255) AS 


    BEGIN 
    DECLARE @Ver varchar( 255 )  
    SELECT @Ver=case 
    WHEN CHARINDEX ('8.00.1',@@version)>0 THEN 'Release'
    WHEN CHARINDEX ('8.00.3',@@version)>0 THEN 'SP1'
    WHEN CHARINDEX ('8.00.5',@@version)>0 THEN 'SP2'
    WHEN CHARINDEX ('8.00.760',@@version)>0 THEN 'SP3'
    ELSE 'unknown' 
end
RETURN (@Ver) 
END

select dbo.ServicePackversion ()

select @@Version

select charindex('8.00.760',@@version)

[blue]DBomrrsm[/blue]

 

[johnv20]

You could just go to enterprise manager, right click on the server & select properties

 

[mrdenny]

This will give you the service pack info and version info for your install.

SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)