Hi ,

I need to insert data into a identity column but not allowed to
use set identity_insert on

can anybody tell me any alternate method

Thanks
Puneet

Use thsi command
Set Identity_Insert Column_name On

And read this satement carefully

If the value inserted is larger than the current identity value for the table, SQL Server automatically uses the new inserted value as the current identity value.

Mohd Azharuddin Ansari
Syntel Inc
Pune