I haven't had any inserts with triggers, but I would think the method I described would not work. I read Alexey's solution and need to step through it. It seems that this is a superior solution in that the insert command is sent along with code to retrieve the ID and results in only one trip to the server. I hadn't seen his solution before. Thanks.
>
>Charlie,
>
>Did you review Alexey's sample referenced elsewhere in this thread with using SCOPE_IDENTITY?
>
>If your tables have triggers, do you still get correct ID using your method?
Charlie