Setting Autoincrement in SQL Server 2012 -
i in designer trying enable auto increment , when trying save changes error shows, using sql server 2012 management studio.
does know why? thank you.
this feature in management studio prevents accidentally dropping , re-creating table without knowing it. can turn off in tools -> options -> designers -> "table , database designers" - option "prevent saving changes require table re-creation".
you should turn off caution feature trying prevent causing issues. recommend against development servers, or better generate script , execute instead. way know commands being executed.
Comments
Post a Comment