Query Execution History logs every SQL statement that you run in a file on your disk or in a table in a database you specify with a connection string. The Query Execution History and Window Content History files are correlated by the same directory and file name so when you search through the Query Execution History you get to see the whole saved Window Content History for that query. sql file so you can even open it in your SSMS. By contrast the Window Content History saves everything in a. If you're working on a large script and never execute it the existing Query Execution History wouldn't save it. This feature fixes the shorcoming of the Query Execution History which is saved only when the query is run. Window Content History saves the whole text in all opened SQL windows every N minutes. This openes the last saved tabs already connected to the server they were connected too before. You can also Restore Last Session by pressing the button on toolbar. Each tab is saved periodically as defined by the interval for Window Content History. Tab Sessions make your work with tabs even easier.
