The identity value is assigned when the row is written to the table. I would have guessed that you would be able to access it from within an INSTEAD OF trigger. I'm surprised that you can't. Would you post the source for your trigger/

-Mike

>Hi Michael,
>
>I don't have problem to found some workaround.
>
>I want know if i can uses IDENTITY generate within INSTEAD OF triggers.
>
>Fabio