Posted by Dan Guzman on 09/04/05 20:43

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@gmail.com> wrote in message
news:1125853679.498850.278490@g44g2000cwa.googlegroups.com...
> 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?
>

• Next in forum: Re: Question about Service Pack
• Prev in forum: Re: Slow Query Through Cold Fusion
• Thread view: Re: Question about Service Pack

[Reply to this message]