Where do I change the optimistic concurrency setting to NEVER in SSMS?
Reason for Question:
This weekend I updated to Visual Studio 2013. I get into my SSMS 2012 and create a simple table for a simple application. I get the optimistic concurrency control error as I play with data in the table. Arrrrr. I read about it and I set a primary key on the table and now I can edit/save etc. but I get the error message each and every time. I do some research and people say, turn it off. Where?
FYI - This is NOT happening to any previously built tables in SSMS. Only my new ones after loading VS2013.