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.2145 (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-ENU
Messages: 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: 2273
I 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.