Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2006-03-23 : 13:34:50
|
| I have my sql server on WinServer2003 standard Edition/service pack 1 installed with sql server 2000When i fire select @@version I get thisMicrosoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) looks like i need to update my service pack with latest version. 1.where can I download the latest version( is it free?)2.If i directly update with service pack 4, does it update all versions3.Do i need to install service pack direclty on the server machine or can I also do it from remote desktop of that server.4. Last but not least...when install the service pack what are the things i need to cehck before and after installation and do i get any issues by doing this. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-23 : 14:16:21
|
| 8.00.2039 is SQL2000 with SP4 - the "SP1" you are seeing is your Windows Service PackBut to answer your questions:1) Microsofts web site. Yes its free.2) Yes3) On the server4) Backup everything, including the system databases. And prepare the users to be chucked off!Kristen |
 |
|
|
|
|
|
service packs