I have tried that, and I get the same error. I have tried to put BEGIN/COMMIT Transactions around each insert statment to see if that would help, but was unsuccessful there as well. I have also tried IDENT_CURRENT(Table1) and SCOPE_IDENTITY() in a similar fasion, but always get the same error.
Thank you Sergey :)
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.