How to restore document sessions

SQL Complete lets you restore closed SSMS document sessions. By default, this option is enabled, and SQL Complete restores the tabs of the latest SSMS session and SQL Server connections, so you can quickly pick up where you left off.

This topic describes the following features:

Enable/disable document restoration

To enable or disable document restoration, do the following:

1. Go to the SQL Complete menu and select Options.

2. On the General tab, select or clear the Enable document restoring option.

Restore a document session

To restore a document session, do the following:

1. Go to the SQL Complete menu and click Documents Sessions.

Documents Sessions

2. The Documents Sessions window opens with a list of your recent sessions. Note that if one of the sessions is running on another SSMS instance, you cannot activate it or perform any action with it in your current SSMS instance - it is disabled.

Documents Sessions window

In the Documents Session window, you can do the following:

  • Double-click your SQL document to activate it.
  • Click the expander arrow next to the document session to see the list of documents opened in the session. When you hover over one of the documents, a hint appears with backup time and data size details for this document.
  • Icon indicates a currently active session. Click to activate another available session to open all its tabs.
  • Click to delete a session.
  • Click to restore the deleted session.
  • Click to restore the deleted document(s). A hint shows you the documents to be restored.

Information on session

To discover how to reopen closed tabs in SSMS, see How to Recover Recently Closed Tabs in SSMS Using SQL Complete.

Restore a recently closed document

SQL Complete can restore SQL documents that have been closed recently. For this, on the SQL Complete menu, click Recently closed documents and select the document you want to restore.

Restore Recently Closed Document

Restore the last closed document

You can also restore the last closed document: On the SQL Complete menu, select Restore Last Closed Document or press Alt+Z.

Close all unmodified tabs

An unmodified tab refers to a tab that has not been changed since it was last saved or opened, whereas a modified tab is the one that has been edited but has not been saved. An asterisk (*) next to the tab’s name indicates unsaved changes in the document.

Unmodified and modified tabs

You can close all the tabs that have not been edited to clear your SSMS editor. To do this, right-click any tab caption and select Close All Unmodified.

Close All Unmodified

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge SQL Complete for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the SQL Complete in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the SQL Complete for your business, request a demo to see it in action.
Ready to start using dbForge SQL Complete for SQL Server?