installed SP3 but @@version shows sp2

9 Jul 2009 2:01 PM

Scott

Hi,

I install SQL 2005 standard edition SP3 which completed with no errors.

When running

select @@ version

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)

I only have a single instance installled.

Installed this:

SQLServer2005SP3-KB955706-x86-ENU.exe

Am puzzlled.

Windows 2003 server 64 bit standard.

Thanks
scott

9 Jul 2009 2:10 PM

Rubén_Garrigós

Hi Scott,

9.00.4035.00 is SQL Server 2005 SP3. "Build 3790: Service Pack 2" refers
to your operating system version.

Use this to check your SQL Server version:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY
('productlevel'), SERVERPROPERTY ('edition')

--
Rubén Garrigós
Solid Quality Mentors

Blog: http://blogs.solidq.com/es/elrincondeldba

Scott escribió:

Show quoteHide quote

> Hi,
>
> I install SQL 2005 standard edition SP3 which completed with no errors.
>
> When running
>
> select @@ version
>
> Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 2)
>
> I only have a single instance installled.
>
> Installed this:
>
> SQLServer2005SP3-KB955706-x86-ENU.exe
>
> Am puzzlled.
>
> Windows 2003 server 64 bit standard.
>
> Thanks
> scott
>
>

9 Jul 2009 2:26 PM

Scott

LOL :-) thank you.

9 Jul 2009 3:55 PM

Dan Guzman

In SQL Server 2008, the SQL Server service pack level is also included in
the @@VERSION string. For example:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
Mar 29 2009 10:11:52
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service
Pack 2)

The SERVERPROPERTY method Rubén suggested works with this and older versions
as well.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

Show quoteHide quote

"Scott" <nospam123@yahoo.co.uk> wrote in message
news:OZYvnEKAKHA.1536@TK2MSFTNGP05.phx.gbl...
> LOL :-) thank you.
>