SQL Complete allows you to reopen restore tabs of the last closed SSMS session. By default, this option is enabled and SQL Complete restores the documents of the latest SSMS session and SQL server connections, so you can quickly continue where you last worked.
This option is available only in SSMS and is not supported in Visual Studio.
Go to the SQL Complete menu, and then click Options.
On the General tab, select or clear the Enable documents restoring option.
Go to the SQL Complete menu, and then click Documents Sessions.
The Documents Sessions window opens with a list of your recent sessions. Please 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.
SQL Complete can restore SQL documents that have been closed recently. For this, in the SQL Complete menu, point to Recently closed documents, and click the document you want to restore.
You can close all the tabs that were not edited to clear your SSMS editor. Right-click any tab caption and click Close All Unmodified.