Hi Michael,

I don't have problem into the trigger, i want identity out of the trigger.

If TRIGGER is FOR (AFTER) type, SCOPE_IDENTITY() return id insert on the table where i exec INSERT, but if i define a INSTEAD trigger, SCOPE_IDENTITY() return NULL.

Example:

-- Batch

INSERT INTO tableWithInsteadInsertTrigger VALUES (....) -- Note*
SELECT SCOPE_IDENTITY() -- this return NULL

Note*. This fired a INSTEAD OF INSERT trigger, and on this a INSERT command is done (within INSTEAD SCOPE_IDENTITY is ok )

Fabio