The first time I open up a script, SSMS will ask me to pick a server connection. But each time after that, it will not. It will auto-connect to the server that I last opened a connection to. I don't want it to auto-connect. I want to force SSMS to ask me each time I open a script which server to use.
Seems like odd behavior but when I open a new query using "Database Engine Query" instead of "New Query" all subsequent .sql file I open ask for database connection until I restart SSMS.