MSSQL: INSERT into table with TRIGGER

MSSQL 2005, SSMS 2005
Perl 5.10, DBI 1.613, DBD::ODBC 1.24

I have an INSERT into a table to which a trigger is attached.

It works alright from SQL Server Management Studio using
SQL Server authentication for user xyz.

Using the same user from the same local machine but from Perl,
this silently fails. By which I mean that the execute call
returns 1 (1 row inserted), but actually none has been inserted
in the main table, and the triggered actions haven't been
executed either.

As said, it works without a problem from SSMS.

Does anyone know if there is anything special about the driver
or the DBI I have to configure in order to get this working?

Thanks!
-- 
Michael Ludwig