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 29, 2012 at 12:20 am
#1531217
As I said in my last post, if you're running the code as a member of sysadmins then permissions are not a problem and you don't need to do anything.
Are you getting any error message when you execute SET IDENTITY_INSERT IdentityTable ON; ?