General information
Forum:
Microsoft SQL Server
Hi Michael,
yes!
I have found the SQL internal problem of this issue.
- SCOPE_IDENTITY() is bind to the last INSERT on the current ambit, but this bind is relative to the ambit level of the stack calls;
when you have a INSTEAD OF INSERT on ambit level never insert si done, INSERT is done on the ambit of the INSTEAD OF INSERT trigger.
I send the solution to the SQL Team for resolve this issue.
Fabio
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only