Article ID: 294311 - View products that this article applies to.
This article was previously published under Q294311
BUG #: 236053 (SHILOH_BUGS)
When all of the following conditions are true, an expected error message may not be returned to the client for a duplicate key insert failure:
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
When coding in a trigger, avoid using SELECT statements which return a result set.
Microsoft has confirmed this to be a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.