Sql 2000 SP3 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql 2000 SP3

I just instaled Sp3 but
select @@version
still return me that notice
Microsoft SQL Server 2000 – 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack did i install sp3 or not?
Yes, 2000.8.00.760 SQL Server 2000 is the signature for SP3, so it would appear it has been applied.
You say ‘still returns’. Did it say this before applying the SP? If so it would appear the SP was already installed, ive no idea if it allows yo to reinstall it again without it at least informing you.

Incidentally, this question is nicely timed, because the full list of version strings are on the front page of this site <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br /<a target="_blank" href=http://www.sql-server-performance.com/default.asp>http://www.sql-server-performance.com/default.asp</a>
This is the message which i received after installation not before.
Anyway it seem that i really installed sp3 because when i am going to server property i could see (sp3)
select @@version still show service pack 2
i suspect this happening because i didn’t unpack it to proposed by wizard directory.
Now i am preparing to instal sp3 on clustered server .
Should i install it on active and passive mashine or just one?
Thank you in advance
You have SQL Server SP3 installed. The number 8.00.760 shows this. Do not confuse the SQL server version with the Operatiing system version and service pack that is mentioned on the line:
"Windows NT 5.0 (Build 2195: Service Pack 2…" /Argyle
Thank you but i still think this statement suppose to return
sql server service pack not the operating system service pack.
When I run select @@version on my server with SP installed, I get the following response: Microsoft SQL Server 2000 – 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 3) The section "Microsoft SQL Server 2000 – 8.00.760 (Intel X86)" refers to SQL Server version and SP level, and the section "Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 3)" refers to the operating system I am running. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com
I just realized you are right
Thank you so much
For reference, a long list of sql hotfixes and their knowledge base articles kan be found here: http://sql.nova.nu /Argyle
Let’s not forgethttp://www.sqlsecurity.com It also has a version/hotfix listing, and a great security checklist, too. ———-
T Kelley
MS, MCDBA, OCA, CIW
]]>