I am trying to insert a row in a table and then call the identity_val_local() function to get the last value of the identity column. However, the function returns null but a row is inserted. All this happens in the body of a stored procedure.
There are some before insert and after insert triggers on that table but they have no impact on the identity column. Is is possible that these triggers are the reason why identity_val_local() returns null? Or maybe some other thing is going wrong?