My problem is that I can't use @@identity for the reason you mentioned.

There is a trigger for insert on table x, that insert a new row to another table.

Also the...

I think that throu OLEDB there would be no problem to retrieve scope_identity().

The store procedure would be a solution but it will be my last choice, because it has to...

Thanks for the solution but the real select is in a UDFunction with many lines and doesn't work properly.