Solved Identity Not Working in SQL Server 2014/ 12/ 17. Identity jumped 1000.

This tutorial is how to solve identity problem when identity jump 1000 instead of 1. its jump 1000 at each restart the SQL server. its happened because of cache.

SOLUTION
1. if you are using SQL server 2012 or 2014 run configuration manager and right click on SQL Server go to the properties. click on startup parameters tab and write T272 and click add, apply and OK.

2. Run SQL Server 2017 and go to new query. write the command and click execute.
~~~~~~~~~~~~~
Subscriber will be notified when I will upload new tutorials in future. Many more new tutorials coming soon, so stay tuned!
https://www.youtube.com/swiftlearn
~~~~~~~~~~~~~
You can also know all the programming techniques, and bug fixing, error solution in my channel Swift learn.
The main topics of this cnannel are c#.net, asp.net, WCF, sql server, crystal report, RDLC report, HTML, CSS, javascript, Android etc.
~~~~~~~~~~~~~
Share this video with anyone if you think as useful.

Please leave any suggestions for future tutorials in the comment section below.
~~~~~~~~~~~~~
Connect with me
https://www.facebook.com/groups/swiftlearn/

All playlist
c# tutorial for beginners Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyXoPn0-4NIdFn8RrQQDdAki

c# linq to sql tutorial Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyVsic1g2CUn2pR5aKjNd3Nc

asp.net tutorial for beginners full Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyUjmHrYfAq1l8pe5eXhkZqF

crystal report c# in sql Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyWao6CC3Eu0srQxJjgkfLsm

RDLC Report tutorial
https://www.youtube.com/playlist?list=PLINPYKVRUHyV3GDbpv4gmaOTf-5aX1ylm

SQL Tutorial for beginners full Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyVOv6mx6xU7HEgGcfLk4Kmz

HTML tutorial full course
https://www.youtube.com/watch?v=dFvd2urgpT8&list=PLINPYKVRUHyWRkhohiZAvrFQntgNexdqz

WCF Tutorial Step By Step with SQL
https://www.youtube.com/watch?v=WCYZpeD2SnE&list=PLINPYKVRUHyXov5R5cAVidtfGWum6TLLT

More Tags
#identitynotworkinginsql #solvedidentitycrisis #identityjumped1000insql #sqlserveridentitycolumnskippingvalues

swift learn,identity not working in sql,identity jumped 1000,solved identity crisis,solved identity problem,identity in sql,sql server identity,identity increament not working,identity,not,working,sql server,jumped 1000,2014,2012,2017,sql server identity column,sql server identity column skipping values,sql server identity auto increment,identity jumped 1000 in sql

Тэги:

#swift_learn #identity_not_working_in_sql #identity_jumped_1000 #solved_identity_crisis #solved_identity_problem #identity_in_sql #sql_server_identity #identity_increament_not_working #identity #not #working #sql_server #jumped_1000 #2014 #2012 #2017 #sql_server_identity_column #sql_server_identity_column_skipping_values #sql_server_identity_auto_increment #identity_jumped_1000_in_sql #identity_column

Скачать видео