BUG: Using Defaults Within a Trigger Results in Access Violation

ID: Q238896

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 18819 (SQLBUG_65)

SYMPTOMS

Sometimes when you use defaults in a trigger to insert into another table, the query returns the following error message:

DBLibrary Process Dead - Connection broken.

WORKAROUND

To work around this problem, provide values for all columns of the table instead of having the column defaults provide the value in the insert statement within the trigger.

STATUS

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

Additional query words: trigger default access violation

Keywords : kbSQLServ650bug
Version : winnt:6.5
Platform : winnt
Issue type : kbbug