I just implement a complicated DB solution with SQL Server 2008, but it is not complated. So I need an tool or settings which allows me with 1 click to open a connection to remote SQL Server where I to execute T-SQL /with copy/paste - for example I modify a SP on my local DB and need to put it production DB/. Now I do this with MS SQL Server Management studio, but it require 3-5 clicks and navigation with Registered servers that I want to automaise as I expect OFTEN to do such operations. The ideal solution is to make a button in the Management Studio which directly open a remote SQL Server and even open a default Database, or Shortcut key but I found no such option. May be this could be provided with an external Adds-Ins?
I’m sure this is a common task for many colleagues. What is the best/fastes tool approach for such kind of operations?