CODEWITHSUNDEEP
sql-server
buckley
buckley

Reputation: 14030

Change the Application Name of SSMS

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

Upvotes: 7

Views: 6792

Answers (3)

G.Borella
G.Borella

Reputation: 48

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.

Upvotes: 2

Pablo Montilla
Pablo Montilla

Reputation: 3050

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

Application Name=<YOUR APP NAME>

Upvotes: 14

Bridge
Bridge

Reputation: 30651

Yes, it's called an Alias. See here for instructions on how to set one up.

Upvotes: 0

Related Questions