How can I catch errors that occured
within a trigger in SQL Server ?

I work with access in front of SQL Server.
A trigger in sql used the statement:

RAISERROR(ErrorNumber , sevirity , -1)

when the error occured, I need to get in access
the very same ErrorNumber that was raised by SQL Server,

does anybody knows how?

thanks for advance
for answering this question

Sara,

It's in the Errors collection, usually Error(0).  Help has details.

    - Rebecca.