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
