BUG: Insert Through View May Cause Duplicated Identity Value

• Microsoft SQL Server, version 6.5

SYMPTOMS

Inserts performed through a view may generate duplicated identity values in the base table if SQL Server's 'open objects' is not configured high enough. If a table has a primary key or a unique index, the insert fails with either of the following errors:

   2627 14 Violation of %s constraint '%.*s': Attempt to insert duplicate
   key in object '%.*s'.

   -or-

   2601 14 Attempt to insert duplicate key row in object '%.*s' with
   unique index '%.*s'.

   Warning: OPEN OBJECTS parameter may be too low attempt was made to free
   up descriptors in localdes() Run sp_configure to increase parameter
   value.

WORKAROUND

To work around this problem, use sp_configure to increase 'open objects' (see the documentation on DBCC MEMUSAGE to find the memory overhead of each 'open object').

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.