unable to load project in visual studio

Just right click on the project file that is not opening go to the edit project and find 

UseIIS and set it as False 

SQL Server Auto Identity Column Value Jump Issue

These links might be helpful to you

https://www.codeproject.com/Tips/668042/SQL-Server-2012-Auto-Identity-Column-Value-Jump-Is
https://blog.sqlauthority.com/2018/01/24/sql-server-identity-jumping-1000-identity_cache/

Dead lock

[SqlException (0x80131904): Transaction (Process ID 109) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]

You can see that error when deadlock happen. I find some use full link that might help you to resolve that issue

1- means on 0- means off
SELECT is_read_committed_snapshot_on FROM sys.databases
WHERE name= 'DATABASE Name'

https://www.youtube.com/watch?v=9NVu17LjPSA
https://www.youtube.com/watch?v=9NVu17LjPSA


https://goo.gl/c5ryq7
https://goo.gl/8JpFwD

https://goo.gl/p4hQ1e
ALTER DATABASE generic SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE