Why does SSMS (MS SQL Server Management Studio) continue to increase the appending numbers to windows and queries even if I open a new one after closing all previous?
For ex., the window header of a newly created query is shown as "SQL query6. sql - localhost.databasename (ComputerName\Administrator (52))".
How one can reuse these "helpful" numbers - 6 and 52?
Now, if to right-click on Windows tab header there are options:
- Copy Full Path
- Open Containing Folder
- opening or copying D:\Documents and Settings\Administrator\Local Settings\Temp
How am I supposed to use this folder in my work?
The helpfulness of the following helpful features are also escaping from me:
- menu File --> Save File As
opens My Documents\SQL Server Management Studio\Projects folder - menu File --> Open File proposes the recently used files by MS Word (where I keep doc files)
What is the rationale under this diversity of paths and how one is supposed to organize the work with SQL script files according to them?