One of my workmates is trying to run a query using the query designer (right click on table, open, select your columns etc) and the query times out after 30 seconds. i tried it on mine and its the same. I never design any queries this way so the settings were default.
I have tried extending the timeout settings through tools - options - designer, restarted SSMS and still no joy, still a 30 second timeout seems to apply.
Anyone know how you can amend this timeout?
ps, the query runs through "new query" in around 5 mins.
Regards
John