This restriction determines what types of modifications you can make to views that include IDENTITY columns. By definition, IDENTITY columns cannot be updated. Updates through a view cannot specify an IDENTITY column value.
Inserts to IDENTITY columns are restricted to:
The table owner
The database owner or the system administrator, if the table owner has granted them permission
The database owner or the system administrator, if they are impersonating the table owner by using the setuser command.
To enable such inserts through a view, use set identity_insert on for the column’s base table. You cannot use set identity_insert on for the view through which you are inserting.
