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
No comments:
Post a Comment