BUG: Using Defaults Within a Trigger Results in Access Violation (238896)
The information in this article applies to:
This article was previously published under Q238896
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 6.5.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB238896 |
|---|
|