Friday, January 13, 2017

Buggish: Visual Studio 2013 - Create table designer never loads

Problem type: hanging
Last status message: "the design surface is loading"; "inspecting database structure"
Steps: Open to database in SQL Server Object Explorer, right click Tables, select Add New Table...

Symptom: Application just hangs with "the design surface is loading" in the main panel, and "inspecting database structure" in the Data Tools Operations tool box.

I've left this open for several minutes, but nothing appears to happen.

Worked couple months ago. Haven't been used VS2013 since then.

Resolution: Changed the timeout period from 60 to 360 in registry: [HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\12.0\SQLDB\Database]
"QueryTimeoutSeconds"=dword:00000168
"LockTimeoutSeconds"=dword:00000005
"LongRunningQueryTimeoutSeconds"=dword:00000000


It is possible that I didn't wait long enough. But after this change, I was able to get the proper windows. I didn't have to wait as long as prior to the change by significant amount, but still had to wait a couple minutes.


Reference:
https://social.msdn.microsoft.com/Forums/Lync/en-US/835ecacd-05ed-4635-9124-922966fc1022/new-sql-standard-database-does-not-load-design-surface-designer-does-not-work?forum=ssdsgetstarted&prof=required