BUG: Insert from Linked-Server Into Table with BIT Field Having a DEFAULT Constraint Causes AV

ID: Q240798

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 56233 (SQLBUG_70)

SYMPTOMS

Inserting a row into a local table that has a BIT column that has a DEFAULT constraint can cause an access violation (AV) if the following are true:

The inserted value comes from a linked server table.

There is no specified value for the BIT column, hence, the DEFAULT expects to be used.

WORKAROUND

Change the BIT column to CHAR or some other datatype that satisfies the business requirement.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : SSrvErr_Log SSrvGPF SSrvISQL SSrvTran_SQL kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug