You can use SET IDENTITY_INSERT command to control this. See BOL for details.

>Hi All:
> I want to insert a new row in my table on sql. I have a PM Key, however I want my program to overwrite this PM Key in my table. I read something about using Identity_Insert set to off. How can I set the Identity_Insert to off, thus over writing the PM Key?
>Thanks
>MA