March 23, 2006 at 11:37 am
I have my sql server on WinServer2003 standard Edition/service pack 1 installed with sql server 2000
When i fire select @@version I get this
Microsoft 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 versions
3.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.
NOTE: production and development instances are on the same machine, do i need to install on DEV 1st and production later?
March 23, 2006 at 11:44 am
1. The servicepacks are free and available at http://http://www.microsoft.com
It could be you have to pass a "genuine" validation first.
2. Yes, the latest servicepack includes all previous versions.
3.You can do that remotely
4.Backup everything first and verify they are ok. In worst case you have to reinstall the sql server. Make sure nothing else is connecting to your databases whilst patching.
If your server is running in AWE mode you need to apply an additional hotfix.
March 23, 2006 at 1:26 pm
You already have SP4 installed. That's what the 2039 is telling you.
Run this:
SELECT ServerProperty('ProductVerion'),
ServerProperty('ProductLevel')
One will tell you the SP level. The other gives you the same code as you already have (equivalent to SELECT @@Version)
You have to 'decode' the value. Go to http://www.sqlsecurity.com Find the link for FAQS and go to the SQL Server Version Database to find out what 2039 equates to. (It means SQL Server 2000 with SP4).
The "(Build 3790: Service Pack 1)" is telling you information about your Windows OS.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply