upgrading SQL 7 to SQL 2000


    Sponsored Links


  • 1. Trying to start SQLSERVERAGENT
    Hi, I have a WIN2k server running SQL2k and for some reason I cannot start the SQLSERVERAGENT service. I am tring to start it using the local system account but it won't start successfully. The error I get is: Could not start SQL server agent. This could be an internal Windows error or an internal service error. Any ideas?? Thanks, Steve Bajada Sr. SQL Server DBA
  • 2. Adding a Processor
    I'm not a DBA, just a network admin. As such I don't have too much experience with the ins and outs of SQL. I've got SQL 2000 on a Windows 2000 platform. We're going to be adding a second processor to the server. I've found the Q article that says the change I need to make to Windows. Is there something I need to do to SQL so it can take advantage of the second processor? Thanks
  • 3. SQL 6.5
    I'm trying to install SQL 6.5 on a windows 2000 server but I'm having problems. During installation, it says that it won't run on this server, but give me an option to continue anyway. Does anyone know if SQL 6.5 will run on a windows 2000 server? Thanks

upgrading SQL 7 to SQL 2000

Postby Peter Milza » Mon, 19 Jan 2004 07:27:35 GMT


I trying to find information on doing an unattended upgrade of SQL 7 SP4 to SQL 2000?  I've only come across documentation in BOL and the web on recording and using an.iss file to perform an initial installation.  We deployed SQL 7 hands free using the method documented in BOL to over 300 servers in our environment and are now looking (finally) to upgrade.  Any thoughts or help you could provide would be greatly appreciated




Sent via Fuzzy Software @  http://www.**--****.com/ 
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Similar Threads:

1.Error -2147467259 upgrading SQL 6.5 to SQL 2000

I'm trying to upgrade several databases from SQL 6.5 SP5a to SQL 2000
and I receive the following error from the Upgrade Wizard:

Export Exit Code: -2147467259 -
c:\progra~1\micros~3\mssql\upgrade\export.exe -CodePage 1252
-DeviceType Pipe -AllTables yes -MasterPath C:\MSSQL\DATA\MASTER.DAT
-DatabaseName AAP -DevicePath \\.\pipe\~cnvpipe0
Time:09-02-2004 17:55:13.272
Error in file CnvBuf.cpp Line=1555 rc=109 Msg=Result Code = 0x0000006d
****Time    : 09-02-2004 17:55:13
An Error occured while exporting table ACCOUNT
Time    : 09-02-2004 17:55:13
An Error occured while exporting database AAP
Time    : 09-02-2004 17:55:13
An error occured while importing table. Please check the error file.
Time    : 09-02-2004 17:55:14
pSql65Server->DumpAllTables () failed. hr=-2147467259

Both SQL Server versions are on the same computer and I log on as a
domain administrator. Also, both SQL services start as Administrator.
DBCC CHECKTABLE on table ACCOUNT doesn't return any errors.
Any suggestions?

Thanks everyone.

2.Upgrade SQL 7 to SQL 2000

Hi Im planing to upgrade a old SQL 7 to SQL 2000
Is there anny issues to be aware of ?
Can someone reccomend some links abut upgrading SQL servers ?


3.Urgent - Upgrade SQL 6.5 to SQL 2000

I want to upgrade my SQL server 6.5 to SQL 2000 using "SQL Server Upgrade
After the upgrade, a message tell me that a user not migrate so the script
to GRANT right on objects not work.
Anyone got an idea ?


4.Upgrading SQL 7.0 to SQL 2000

I have a SQL 7.0 server, when I run the upgrade to SQL 
2000 I get the following error, "error running script: 
message.sq1 (1)".  Any thoughts?


5.Upgrade SQL 6.5 to SQL 2000

I have upgraded a database from SQL 6.5 to SQL 2000 using 
the Microsoft SQL upgrade utility.   Some fields in the 
SQL 6.5 database are defined as float.  For these fields, 
the values are being saved in SQL 6.5 correctly with two 
decimals point(for example 10.45).  However after running 
the upgrade utility, some of the values are being altered 
so that a value of say 10.45 now shows as 
10.44999999999999 in SQL 2000.  Any ideas as to why the 
upgrade is altering data in fields defined as datatype of 

6. Upgrade SQL 7.0 to SQL 2000

7. Upgrade SQL 7 to SQL 2000 Failed

8. Upgrading SQL 6.5 to SQL 2000



Who is online

Users browsing this forum: No registered users and 74 guest