473,399 Members | 2,159 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

SQLServer 8.0 Sp3 to sp4 upgrade

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?
Oct 16 '06 #1
0 2308

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: David Greenwood | last post by:
I posted this under 'microsoft.public.sqlserver.client' but got no reply. Any help with this problem would be greatly appreciated --------------------- I developed a database under SQL Server...
5
by: tawfiq.choudhury | last post by:
We were running a 4 processor server with 8 GB RAM and 800GB hard disk space on Windows 2000 server and SQL Server 2000. Recently we have upgraded the server to 8 processor and added another...
1
by: mdurliSPAMFILTER | last post by:
Hello, I developed a win32 .exe CGI that connects to a clustered SQLServer to report some data. The software is written with Borland C++Builder. This is the oledb string:...
3
by: Devonish | last post by:
I am planning to convert an existing Access database which has a back end (data tables and relationships only) on a server and a copy of the front end (form, queries, reports) on each of about a...
2
by: Jenniflower | last post by:
Hi Gurus, Our system is using SqlServer 2005 on XP.( On my machine,only this application access SQLServer.) The sqlserver memory is configured to 128MB (Min)~512 MB(Max) After our system get...
2
by: =?Utf-8?B?SmVmZnJleQ==?= | last post by:
I have some old ASP programs w/ SQLserver 2000 databases. Now I am developing ASP.NET projects using VB 2005 and SQLserver 2005. What are the best procedures to develop and test the ASP.NET...
5
by: Ben | last post by:
We recently upgraded our MS SQL Server 2000 to 2005. Here is what we did: 1. Perform backup of the database from the old server. 2. Created a blank database in the new server. 3. Restored the...
7
by: Academia | last post by:
I was told that SqlServer express should get installed when VS2008Pro is installed (that is it is on the same DVD). I had a couple of errors during vs2008's installation and I don't see any...
3
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4)...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.