Microsoft KB Archive/238896

= BUG: Using Defaults Within a Trigger Results in Access Violation =

Article ID: 238896

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



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.

Additional query words: trigger default access violation

Keywords: kbbug kbpending KB238896

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.