Problem with SP4 installation and REPLSYS.SQL

I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
installation has 5 named instances. I was able to install SQLServer SP4
onto 4 of the named instances with out any problem. When I installed the
SP4 update I was logged on as the local administrator and used Windows
authentication.
When I attempted the install on the last instance, it failed running the
REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and it
told me that the error was with procedure sp_addextendedproc in the master
db. The script tried to execute the following command:
sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
The error says that there is already an object named 'xp_mergexpusage' in
the database.
I have looked at the list of extended stored procedures listed in the Master
DB and I cannot see the xp_mergexpusage stored procedure anywhere. Is it
hidden somehow? I can see the stored procedure in the other instances that
were sucessfully updated but not in the instance that fails.
Has anyone else run into this problem when installing SP4?
Is there a way to attempt a delete of the xp_mergexpusage extended stored
procedure incase it is hidden somehow?
Any help would be greatly appreciated.
Greg PaganI found the answer to this issue myself.
Turns out the problem had nothing to do with SP4 at all. It just pointed
out the underlying issue.
I had corruption in the master data base that somehow messed with the
DBI_NextID. The value of that indicator was out of sync with the max(ID)
indicator. The DB_NextID as less than the Max(ID) which was telling the
system that the object already existed. The fix which came from
sqlforums.windowsitpro.com is to generate new DB_NextIDs by creating and
droping simple tables in master until the counter for DB_NextID grows larger
than max(ID). It took me over 700 table creates to get to that point.
After that the SP4 Update ran successfully.
Thanks anyway.
"Greg Pagan" <gpagan@.thehartford.com> wrote in message
news:O%23CHMX3VGHA.5692@.TK2MSFTNGP09.phx.gbl...
>I have a SQLServer 2000 SP3 running on Windows Server 2000 SP4. My
>installation has 5 named instances. I was able to install SQLServer SP4
>onto 4 of the named instances with out any problem. When I installed the
>SP4 update I was logged on as the local administrator and used Windows
>authentication.
> When I attempted the install on the last instance, it failed running the
> REPLSYS.SQL script. After some digging I found the REPLSYS.OUT file and
> it told me that the error was with procedure sp_addextendedproc in the
> master db. The script tried to execute the following command:
> sp_addextendedproc 'xp_mergexpusage', 'xprepl.dll'
> The error says that there is already an object named 'xp_mergexpusage' in
> the database.
> I have looked at the list of extended stored procedures listed in the
> Master DB and I cannot see the xp_mergexpusage stored procedure anywhere.
> Is it hidden somehow? I can see the stored procedure in the other
> instances that were sucessfully updated but not in the instance that
> fails.
> Has anyone else run into this problem when installing SP4?
> Is there a way to attempt a delete of the xp_mergexpusage extended stored
> procedure incase it is hidden somehow?
> Any help would be greatly appreciated.
> Greg Pagan
>
>