| Author |
Topic |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2005-02-02 : 16:34:45
|
| Hi all,Please help me answer my dumb questions for me.I installed an evaluation copy of sql server 2k enterprise edition.After this installation, I downloaded and installed sp3a for sql 2k.A week ago, we installed a full licensed version of sql server 2k standard edition.I was under the impression that the sp3a patch we installed earlier would take care of t hat.But I just got a strong worded email from our dba that no sp3a patch was not applied to the newly installed sql server 2k.How can you check to determine whether sp3a patch is installed on sql 2k or not?Last but not list, when I tried installing that patch now, I got a message that said that sp3a had already been installed.So how can sp3a be applied to sql server 2k?Sorry for these cheap questions and I appreciate your response. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2005-02-02 : 16:46:55
|
| Ooh, that was pretty quick...thank you Tara.Please pardon my follow up questions.I ran that but the output is too long, how can I shorten it?2, assume that the sp level is below 3, how can I install sp3?I tried installing it but I got a message that said it has been installed already.I need to go to my dba and say, I am sorry, I am installing it now or it is installed already".Thanks again for quick response |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-02 : 16:48:44
|
| I don't know what you mean by the output is too long.Please post the exact error message that you are receiving when you install sp3a.Tara |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2005-02-02 : 16:52:34
|
| What I mean by output is too long is when I run this query you gave me:SELECT @@VERSION _____________________________________________________________Response here overlaps the screen and it doesn't give you enough room to scroll to read everything.Also when I tried to install sp3, I am not getting an error.It just says that sp3 is already installed. |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2005-02-02 : 16:57:01
|
| Ok, I see it says service pack one but service pack 3 is already installed.I thought that installing it on the server where sql serveer is running will take care of that? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-02 : 18:32:41
|
| When you run SELECT @@VERSION, just expand the output to see it. Or you can change your result window to output to text instead of grid mode. It's in the Query Analyzer options.If it says sp1, then sp3a is not already installed.Tara |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2005-02-03 : 08:33:48
|
| In my last post, I indicated that I was able to read the output which clearly says only sp1 was installed, not sp3.The question that I have now is I installed sp3 on the server where sql server SE resides.When I attempted to install sp3 again, a message says sp3 has already been installed, even though sql server SE says it is not installed.Where is sp3 installed?Is it not on the same server where sql server SE resides?That's all I would like to know now.Thanks much |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-03 : 12:34:09
|
| Maybe you have a named instance and you aren't selecting that inside the sp3a installation. It needs to be installed for each instance. And it needs to be run on the server where the database engine exists.Tara |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2005-02-17 : 10:48:56
|
| I know this post is sort of old but I figure it is important to continue from this thread so that anyone attempting to help will have an easier catching up on what is going on.Ok, I had indicated in this thread that we had an eval copy of sql server enterprise edition.We later upgraded that copy to full version SE.We have already applied sqlsp3 to the eval copy but for some reason, when we upgraded to SE version, it still reads Service pack 1.I did a lot of research and I was told to uninstall the eval copy because, according to my research, since the eval copy is an enterprise edition, it takes precedence over the SE copy.As a result, any patches will not affect the SE version.Just now, I uninstalled the eval copy, then re-applied the sql2ksp3 patch but I still see the sql server SE copy indicate it is still at sp1 level.Can someone, please tell me what I am doing wrong, please?Thanks in advance |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-17 : 12:33:52
|
| I would call MS: 800-936-3100.Tara |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2005-02-17 : 13:49:01
|
| I just found out what I was doing wrong.I just discovered that any time I tried to install sp3, I would get a message that says sp3 has been successfully delivered.I had assumed all along that that message meant that it had been installed.It turned out that I had to find the folder where the unpacking was delivered, double-clicked on setup.bak, and it installed sp3 on the named instance.I still need to find a way to determine whether or not it was installed successfully, even the message it was.This syntax = SELECT @@VERSION doesn't tell me that.I say this because the version we uninstalled had sp3 but when I ran that code on it, it said service pack 1.So there is got to be a way to check the most current version on sql server, not windows server.Thanks all for the assistance.-- |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-17 : 13:51:55
|
| SELECT @@VERSION is the way to tell. If it doesn't report 760 or higher, then you don't have sp3 installed on that instance.Tara |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2005-02-17 : 14:13:00
|
| Ok, I finally got it working now.For those interested, to know the current sp version your sql server, just run XP_MSVER and like Tara said, look for 8.00.760.If you find it, you are at sp3 or higher.Tara, thanks again for all the help.--s |
|
|
|
|
Applying sp3a patches to sql 2k