SQL Prompt keeps a history of query tabs you open in Management Studio.

Browsing tab history

To browse your tab history, on the Management Studio toolbar, click Tab History:

The tab history window is displayed:

The tab history window shows the following information about each tab:

• the file name

• the SQL Server and database the tab was connected to
• the time the tab was closed

• the contents of the tab (SQL code)

  All text in a tab (which may include sensitive information) is saved to the history. Find out how to remove tabs from the history.

To view a list of tabs that are currently open, click Open tabs:

Renaming a closed tab

1. In the tab list, right-click the tab you want to rename, and click Rename:
   
2. Type a new name for the tab, and press Enter.

Closing an open tab

In the tab list, right-click the tab you want to close, and click Close:

Removing tabs from the history

You can remove a single closed tab, or a set of old closed tabs from the history.

To remove a single tab, in the tab list, right-click the tab you want to remove and click Remove:

To remove old tabs, in the tab list, right-click the oldest tab you want to keep and click Remove tabs older than this:

Restoring open tabs

When you start Management Studio, SQL Prompt automatically restores open tabs from your previous session.

If you don't want SQL Prompt to restore tabs:

1. On the SQL Prompt menu, click Options.
2. Under Tabs, click Tab history:
   
3. Under Open tabs, clear the Restore open tabs when SQL Server Management Studio starts check box.