Change the Application Name of SSMS

Question

Is it possible to change Application Name that SSMS (Sql server Management Studio) uses when making a connection? We need to alter it so we can distinguish different instances. I believe this is not an option in the settings.

Kind Regards, Tom

Answer 1

In the connection dialog, go to Options, select the Additional Connection Parameters tab and write:

Application Name=<YOUR APP NAME>

Answer 2

As explained by the docs for APP_NAME():

To set an application name in Management Studio, click Options in the Connect to Database Engine dialog box. On the Additional Connection Parameters tab, provide an app attribute in the format ;app='application_name'

However i've only managed to get this to work on a fresh session of management studio, ie. close the program and add the parameter on the first connection to said database.