Re: Question about Service Pack

You are running SQL Server 2000 SP4. The SP2 in the @@VERSION string is the
OS service pack level.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"SQL Server" <alderran666@xxxxxxxxx> wrote in message
news:1125853679.498850.278490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> In query analyzer
>
> If I run this
> SELECT @@version
> I get this result
> -------------------------------------------------------
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
> May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation
> Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
>
> (1 row(s) affected)
>
> If I run this
> SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
> I get this result
> --------------------
> SP4
>
> (1 row(s) affected)
>
> What's the deal am I at SP2 or SP4?
>


.

Relevant Pages