Online Documentation for SQL Manager for SQL server

Query Data


CheckBox Show actual execution plan on query execution

If this option is checked, the query plan is displayed automatically upon query execution in Query Data.

 

CheckBox Show result for each query

With this option checked, when you execute two or more queries (divided by "GO"), the result of each query will be displayed one by one. Otherwise, only the result of the last query will be displayed.

 

CheckBox Show results on Edit tab

If this option is checked, the Results tab is displayed as a separate tab.

 

CheckBox Execute selected text separately

Check this option to allow execution of the selected statement separately.

 

CheckBox Write only successfully executed queries to database SQL log file

If this option is checked, unsuccessful queries will not be saved to the Query Data log file (see Setting log options in the Database Registration Info dialog).

 

Environment Options - Tools - SQL Editor

 

 

CheckBox Don't save queries automatically for the next session

If this option is checked, the SQL query text will not be saved. Otherwise, it will be saved in Windows registry and will be therefore available in the next application sessions.

 

CheckBox Always save changes in Favorite Queries before closing

This option enables/disables saving changes in SQL queries marked as Favorite automatically upon closing the editor.

 

CheckBox Same queries for all databases

With this option enabled, Query Data stores all queries in a shared repository, so that switching to another database does not cause loading queries of that database (applying this option does not affect currently opened copies of Query Data). The value of the option can be changed freely without any risk to lose the query repository content.

 

CheckBox Refresh DB Explorer upon successful DDL statement execution

If this option is selected, the content of DB Explorer is refreshed each time a DDL statement is executed successfully in Query Data.

 

CheckBox Open server cursor

This option determines whether the application should attempt to open server cursor. If this option is ON, the result dataset is processed with server resources, otherwise it's processed on the client side.

 

CheckBox Get info messages

This options enables receiving of server messages and PRINT command results.

 


See also:

Query Data