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
- Restore a document session
- Restore a recently closed document
- Restore the last closed document
- Close all unmodified tabs
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.
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 will not be able to activate it or perform any action with it in your current SSMS instance - it is disabled.
In the Documents Session, 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.
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 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
You can close all the tabs that were not edited to clear your SSMS editor. For this, right-click any tab caption and select Close All Unmodified.
