Michel,
You need to issue a
SET IDENTITY INSERT database.dbo.tablename ON
on the table to be updated then
SET IDENTITY INSERT database.dbo.tablename OFF
as only one table can have set identity insert on per transaction.
Woodie Westbrook
I came, I saw, I compiled.
