>If you are trying to keep the identity column in the new table in tact then you can't bulk copy but you can do an insert select. ex.
>
>INSERT INTO newdatabase..newtable(AllColumnsExceptIdentity FROM SELECT AllColumnsExceptIdentity FROM ..)

I see. Being lazy I hoped to avoid writting all the fields. I can probably try to generate an Insert procedure then and modify it accordingly.

Thanks a lot.

If it's not broken, fix it until it is.


My Blog