Right, but that's not the default behavior. I have used it before when importing data that needed to keep the PK.
>
>You can set Identity_Insert ON to insert into the column. The only use I've seen for this is when copying table data that need to keep their primary key (the identity column) intact because other tables have FKs pointing to it.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer