Thursday, January 14, 2016

SQL Server Management Studio Connection Button

I use SQL Server Management Studio with multiple server instances daily. I'm usually running different queries on those different servers. Then I end up opening a query that's supposed to run on Server A, but the active connection is Server B. So the query doesn't run.

Until recently I would have closed the file and reopened it after selecting the correct server. It was annoying, but it worked. Then a co-worker of mine introduced me to the SQL Server Management Studio Connection Button (SSMSCB).



When you click this little guy you can select which server you want to switch your current file to. It's amazing and makes life livable again!

No comments:

Post a Comment