Thank you

I have already tried this but it doesn't solve the permissions problem unfortunately.

SQL Server Authentication

I am having problems granting permissions when the trigger is fired via the application software. The application is multi user and any user could cause the trigger to fire. I...

Thanks for you reply.

A trace is impractible because this problem has only occured twice in three months.