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 |
|
putane.sanjay
Yak Posting Veteran
77 Posts |
 Posted - 2006-12-26 : 02:37:30
|
| Hi my system os is windows xp professional version 2002 sp2& i have installed ms sql server 2000version is Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) i want to update seveice packs,what are the service packs i have to update for sql server 2000 give me details.i need ur suggestion please help meregardsPM SANJAY |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-26 : 03:04:52
|
| You should upgrade your SQL Server to the latest service pack available i.e. Service Pack 4.The link for download is:[url]http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
putane.sanjay
Yak Posting Veteran
77 Posts |
Posted - 2006-12-26 : 03:16:59
|
| now i tried to update sp4 but it is giving error "the instance name specified is invalid" |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-12-26 : 03:55:21
|
| did you download the MSDE SP4 instead of SQL Server SP4?-ec |
|
|
|
putane.sanjay
Yak Posting Veteran
77 Posts |
Posted - 2006-12-26 : 04:31:21
|
| i downloaded SQL2000.MSDE-KB884525-SP4-x86-ENU |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-26 : 05:37:29
|
| Download SQL2000-KB884525-SP4-x86-ENU.EXE if you have 32-bit system / SQL2000-KB884525-SP4-ia64-ENU.EXE if you have 64-bit system.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
putane.sanjay
Yak Posting Veteran
77 Posts |
Posted - 2006-12-27 : 02:32:14
|
| thank u |
|
|
|
|
|
|
installing sevice packs