November 21, 2006 at 2:50 pm
SQL Server Management has two tool bars for editing and executing SQL.
A business analyst was using the Query Designer Toolbar to create and execute queries. To enable this toolbar, you need to Open Table through Object Explorer. For large tables you will to stop the retrieval of rows.
Any long running query that is executed through this toolbar would timeout after 30 seconds. When I executed the same SQL through the SQL Editor Toolbar it would run until completion.
The Query Execution>SQL Server>General> Execution Timeout is already set to 0.
Does anyone know how to change this 30 second timeout setting for the Query Designer Toolbar?
David Bird
November 22, 2006 at 8:28 am
Use the "Design Query in Editor" toolbar button to use the graphical query designer. It won't run queries, but when you're finished the query is automatically pasted into the active query window at the last cursor position. (So be careful you know where the cursor is when you press the button.)
The Open Table function is intentionally limited to short queries because the result grid is an active editable control. It is much more resource-intensive on the client as well as the server. If there is a way around the 30 second timeout, don't use it. Definately don't give non-DBA types a better tool to lock up your databases with.
November 22, 2006 at 10:25 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply