I am occasionally getting a deadlock error inside a trigger in SQL Server 2000.

However this error is not being reported back via ADO to my ASP application, therefore the user thinks that everything has gone OK, whereas actually their transaction has been rolled back.

I have seen a system where this error was reported back via ADO, but I do not know how it was done.

Any suggestions?