I have an asp which updates a SQL table which has 3 triggers attached to it to capture the table Insert, Update and Delete action.

I assign the IUSR user db_owner and System Administrator right. Calling stored procedure from the asp is no problem. The same goes for updating a SQL table, i.e. no problem at all. I hit HTTP Internal server error during the update of the SQL table which has the 3 triggers. The Update action will active the update trigger to log down the update action.

Can anyone give me any idea why I'm hitting this error? I already given the full rights to the IUSR user.

Please help.