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 code
- the SQL Server and database the tab was connected to
- the time the tab was closed
To view a list of tabs that are currently open, click Open tabs:
Renaming a closed tab
- In the tab list, right-click the tab you want to rename, and click Rename:
- 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:
- On the SQL Prompt menu, click Options.
- Under Tabs, click Tab history:
- Under Open tabs, clear the Restore open tabs when SQL Server Management Studio starts check box.