Fixed it - no need to reply!
Fixed it - no need to reply!
Justyn
Last Activity: Jun 9 '06, 01:02 PM
Joined: Jun 9 '06
Location:
-
New trigger stops scope_identity / @@identity from working
Hi everyone, I hope someone can help me out!
I have added a trigger that gets fired on INSERT and which itself inserts data into another table WITHOUT an identity
I used to get back the @@IDENTITY and I changed this to get back the SCOPE_IDENTITY so I was not affected by the trigger.
However, after adding the trigger I get this error regardless of whether I use @@IDENTITY or SCOPE_IDENTITY:
...
No activity results to display
Leave a comment: