sql server odbc: Hello, All

I am getting the following problem trying to insert value in the MS SQL 2005
table that has trigger on insertion taking some time to execute (it inserts
1000 records in another table).
The problem is that SqlExecDirect returns immediately while trigger is still
executing, causing problem with inserting original record - it's not being
inserted at all. Can anyone suggest solution of this problem?

Thank you in advance
Dmitry