June 26, 2006 at 9:30 am
We installed service pack 4 on our SQL Server 2000. It runs through the install fine without any errors but when you check to see if it is applied (SELECT @@VERSION) it is still at the old version. We looked at the dlls and exes all but 15 of them have been updated. Does anyone have any suggestions?
June 26, 2006 at 11:14 am
Is there only one instance, or do you have several SQL Server instances? If you have more than one instance, you must run the upgrade for each instance.
-SQLBill
June 26, 2006 at 12:07 pm
No we only have one instance on the machine the default.
June 27, 2006 at 7:49 am
A first palce to look, besides system and application logs is sqlsp.log - which should be located in the windows directory on that machine. Look for error messages in there - it normally ends with non fatal errors 1. What kind of error messages do you see? Is there AV software on that server? If so turn it off while you apply sp and subsequent hotfix 2187.
June 27, 2006 at 8:16 am
I looked in teh sqlsp.log already the only error I seen was find the x86\FullText\MSSearch\Search\SearchStp.exe. We do not use full text on this server and this error message is the same as on other systems that the insall has been successful on. We already tried turning off the AV and that did not work.
Can you think of anything else?
Thanks.
June 27, 2006 at 10:39 am
I've seen this same thing happen when applying SP4 to one of our test servers. After rebooting the server the version numbers were correct.
June 27, 2006 at 11:42 am
We had rebooted the server several several times with no luck. It is not even replacing the exe for SQL Server.
October 4, 2007 at 8:46 pm
Can you post the output of the
select @version
please?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply