Anyone, I am receiving an error upgrading MSDE sp3 to sp4. The error in the log is this:
Running upgrade script 11 of 12 (sp4_serv_uni)
Running script :
-n -b -d master -Slpc:DEVDP\JDELOCAL -i "C:\Program Files\Microsoft SQL Server\Mssql$JDELocal\DataMSSQL$JDELOCAL\Install\s p4_serv_uni.sql" -o "C:\Program Files\Microsoft SQL Server\Mssql$JDELocal\DataMSSQL$JDELOCAL\Install\s p4_serv_uni.out" -E
osql.exe did not return successfully.
First attempt at executing script sp4_serv_uni.sql failed; retrying.
Running script :
-n -b -d master -Slpc:DEVDP\JDELOCAL -i "C:\Program Files\Microsoft SQL Server\Mssql$JDELocal\DataMSSQL$JDELOCAL\Install\s p4_serv_uni.sql" -o "C:\Program Files\Microsoft SQL Server\Mssql$JDELocal\DataMSSQL$JDELOCAL\Install\s p4_serv_uni.out" -E
osql.exe did not return successfully.
The log file sp4_serv_uni.out reads this:
Configuration option 'allow updates' changed from 1 to 1. Run the
RECONFIGURE statement to install.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
(26 rows affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(0 rows affected)
(1 row affected)
Creating 'sp_addlogin'.
Creating 'sp_change_users_login'.
Creating 'sp_addalias'.
Creating 'sp_dropalias'.
Creating 'sp_configure'.
(0 rows affected)
(1 row affected)
Msg 2601, Level 14, State 3, Server DEVDP\JDELOCAL, Line 3
Cannot insert duplicate key row in object 'spt_datatype_info' with
unique index 'datatypeinfoclust'.
The statement has been terminated.
Does anyone know what I could have done wrong?