Article ID: 239475 - View products that this article applies to.
This article was previously published under Q239475
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 56102 (SQLBUG_70)
In certain circumstances, when you perform the following steps in the exact order listed, a handled access violation (AV) may occur:
Before adding the new primary key constraint, make sure that there are not any duplicate or null values in the column (or columns) on which the key is being added.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack SP2 for Microsoft SQL Server 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspxFor more information, contact your primary support provider.