Microsoft KB Archive/133406

{|
 * width="100%"|

FIX: Second LOAD DB of 4.2x DUMP May Corrupt New System Tables

 * }

Q133406

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 10969 (6.00)

SYMPTOMS
If you load a Microsoft SQL Server version 4.2x DUMP into the same SQL Server version 6.0 database twice, the second load results in 1902 errors on the sysreferences and sysconstraints system tables.

CAUSE
This problem only occurs if you LOAD DATABASE into the same database and if SQL Server is not restarted between LOAD DATABASE commands.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.

MORE INFORMATION
These errors are only visible to the user if you manually issue the LOAD DATABASE command. The database is not marked suspect, and the upgrade appears fine otherwise. The database, however, is corrupt, and the test is to run sp_help on either of these two tables. If a 602 error occurs, then this bug is the problem.

Additional query words: sql6 Windows NT upgrade

Keywords : kbusage

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600