Nigel ---

I'm confused: An identity datatype column in SQL Server maintains itself; you don't attempt to update it from the client end at all....so..??


>Another Insert question. My SQL PC is busy at the moment so I can't test this...
>
>Can you *insert into tablename select * from othertable* when you have an identity column in the table? Or would it be better to have the identity column in the *from* table and protect it in the receiving table??