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.

enter image description here

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

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

Nuget pack csproj using nuspec -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -