I'm importing like this http://www.sqlservercentral.com/articles/T-SQL/68927/

Lynn Pettis (6/27/2012)

---

anush_tar (6/26/2012)

---

Sean Lange:

I have After Trigger on table, that's why I can't use SCOPE_IDENTITY() or @@IDENTITY. IDENT_CURRENT is not limited by scope and session.

That's why when 2...

Sean Lange (6/26/2012)

---

What do you mean they work wrong??? The don't work wrong but each of...

Sean Lange:

I have After Trigger on table, that's why I can't use SCOPE_IDENTITY() or @@IDENTITY. IDENT_CURRENT is not limited by scope and session.

That's why when 2 or more people...

Sorry I had to say working only on SQL Server 2005:-D I want something like it to work on sql server 2008 R2.

This is a part of SP, I pass...

P.S. IDENT_CURRENT() , Scope_Identity() , @@Identity work wrong when several people work parallel.