in reply to Will an MS SQL db table trigger affect the value returned by scope_identity?

Unless you are getting the result you expect when using the interactive client, I don't think Perlmonks is a useful forum to ask your question. This is a Perl forum, specialists of the MS SQL dialect are found elsewhere.
  • Comment on Re: Will an MS SQL db table trigger affect the value returned by scope_identity?

Replies are listed 'Best First'.
Re^2: Will an MS SQL db table trigger affect the value returned by scope_identity?
by wreade (Initiate) on Dec 15, 2011 at 14:11 UTC

    JavaFan: thanks for your reply. One goal of my post was to confirm that others did not hit this issue (a scope identity isn't returned from a table with triggers) due to an issue with DBI. In other words, I want to be confident that I can eliminate Perl and DBI as the source of the issue.