Home Forums SQL Server 2008 SQL Server 2008 - General remove identity property RE: remove identity property
MissTippsInOz
Hall of Fame
Points: 3160
More actions
August 28, 2012 at 11:49 pm
#1531206
Permissions issue? IDENTITY_INSERT requires that you are the owner of the table or are a member of db_owner or db_ddladmin on the database.
Have you correctly qualified the table name with the schema?