SQL Server Performance Forum – Threads Archive
find S_pack,hotfix applied?
Hi i am in a effort to setup a new server with same config as old.So i just quried old server for version and got following result . >Microsoft SQL Server 2000 – 8.00.760 SQL . *)This is servicepack 3 or 3a .how to find it out? do these have any difference ? *)as sp4 already released ,can i directly download from MS website?does it ask any info like licence or somthing ? -Rajivhttp://vyaskn.tripod.com/sqlsps.htm —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
The only way I know to see the difference between SP3 and SP3a (that both show 8.00.760) is to look at the version number of the Net-Library file, Ssnetlib.dll. If the version number of this file is 2000.80.760.0, you have SP3; if the version number of this file is 2000.80.766.0, you have SP3a. Note later patches will patch this file version even higher. You can download SP4 for free from www.microsoft.com/sql/
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37 is a good one to track about all the hotfix & SP releases. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi ,
I have sp3 with all my SQLserver boxes and now planing to install sp4 .Is this i am supposed to do? >download sp4 from MS website
>stop SQLSERVER and AGENT service
>install sp4
>restart all services. Or is there anything to be done additinaly?does it need a restart of server?
You have to use Microsoft download site to get SP4 and you must restart services after you apply SP4 on SQL Server. But test the performance on test environment before taking it on production. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
In MS site, i could see following.I am confused which one to download/install .Can someone guide me? http://www.microsoft.com/downloads/…8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en ReadmeSql2k32asp4.htm
66 KB ReadmeSql2k32desksp4.htm
154 KB
ReadmeSql2k32sp4.htm
163 KB ReadmeSql2k64sp4.htm
71 KB SQL2000.AS-KB884525-SP4-x86-ENU.EXE
45509 KB SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
80362 KB SQL2000-KB884525-SP4-ia64-ENU.EXE
50237 KB SQL2000-KB884525-SP4-x86-ENU.EXE
68536 KB
Hi ya, it depends… if you’re upgrading Analysis Services then download the sql2000.AS one
if you’re upgrading MSDE then download the sql2000.MSDE one
it you’re upgrading the sql2000 64 bit version then download the ia64 one
otherwise download the sql2000 x86 one Cheers
Twan
Take SQL2000-KB884525-SP4-x86-ENU.EXE file and download and if you’ve any of the desktop edition of SQL then use SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE file. Before that have a thorough read thru README.HTML files. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>