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 |
|
manadrain
Starting Member
2 Posts |
 Posted - 2008-12-02 : 12:07:17
|
| We have a handful of servers running SQL 2000 on Windows 2000 SP4. Just recently we installed SP4 on the SQL Servers and are now running build 8.00.2050. However we ran into an issue with one of the applications that appears to have the issue fixed with build SQL Server 2000 build 8.00.2148 (KB 901212). FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 Service Pack 4 I have downloaded the hotfix from Microsoft that is to address this issue. However it does not appear that I can apply this update because it thinks it has a newer build on it. When I try to install the hotfix I am unable to select any updates and have the following messages:File Name: SQL2000-KB903086-v8.00.2148-x86x64-ENUMessages: This SQL Server instance you are currently running already contains the update you are trying to install. You do not need to install the update. A Hotfix of build equal to or greater than the following should be downloaded: 2273I am not a SQL admin so I am trying to learn this as I go along. Any advice on how to patch the server to at least build 2148 would be greatly appreciated. |
|
|
manadrain
Starting Member
2 Posts |
Posted - 2008-12-02 : 14:58:04
|
| I think I have found the problem...at least I can recreate it. I took a VM and installed SQL 2000 and ran SP4. I am running version 2039 as expected. So I was trying to figure out where 2050 was coming from and I figured that it was being pushed from our internal WSUS box. Sure enough I can install Hotfix build 2148 ontop of SP4 without any issues. I then tried to remove Hotfix 2148, reboot the server, and then apply Hotfix build 2050 manually. Then I tried to apply Hotfix update 2148 and I have the same issue as I described above. It looks like the update that is being pushed from our WSUS server KB948110 Hotfix update 2050 to any SQL 2000 server is causing an issue. Has anyone had this problem before? |
 |
|
|
irexus
Starting Member
2 Posts |
Posted - 2008-12-23 : 07:04:43
|
| I have exactly the same situation on two Windows servers (2000 & 2003) where "Hotfix 2050 for SQL Server 2050 ENU (KB948110)" has been applied after the SP4. There's no way to install the hotfix KB901200 (== KB903086) as I can see because the version of Sqlservr.exe is 2000.80.2050 and not 2000.80.2039. I'm going to test uninstalling KB948110, installing KB903086 and reinstalling KB948110 again in the virtual environment to observe how SQL Server behaves in the meantime. |
|
|
|
irexus
Starting Member
2 Posts |
Posted - 2008-12-23 : 09:24:29
|
| After thorough testing I could realize that:- uninstalling KB948110 required server restart; the database engine started correctly without any strange issue;- installation of KB903086 went smoothly and the SQL Server has been upgraded to 8.0.2148- I could run KB948110 fo SQL Tools only while reinstalling it againI didn't notice any problems however I recommend to patch SQL Server with the latest patch available at the moment (KB946584, http://support.microsoft.com/?kbid=946584, the hotfix is cumulative), just to fix every possible bug found on the server.Regards,Ireneus Pisanko |
|
|
|
|
|
|
Trying to update SQL 200 SP4 Build 8.00.2050