Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Monitor > Background Processes

Stop Background Processes

Use the Background Processes window to stop SQL statement execution or database object and web page retrieval.

To stop background processes

  1. Select View | Background Processes from the menu (ALT+V+A).

  2. Click in the Background Processes toolbar to stop all processes.

    or

    Click to the right of the running process to stop that process.

    Troubleshooting: When running processes from multiple Editor windows in the background, the statement from the initial process must complete before the statement in the next Editor begins because the connection is shared between Editors. You can specify that each Editor use a separate connection in Tools | Options | Editor | General. See General Editor Options for more information.

Configure Background Process Options

To... Use this Option Page...

Retrieve objects for the Database Explorer and Object Explorer in the background

Explorer | General

Execute SQL statements in the Editor in the background

Database | General

Specify the number of seconds to elapse after a running background process completes before receiving a notification

Environment | General

Tip: You can view processes currently running in the background in a progress bar located on the lower right side of the status bar. While running, you can click the progress bar to open the Background Processes window.