Change application name in SQL Server session

• Jason Hall

  Hall of Fame

  Points: 3906

  More actions

  March 3, 2006 at 7:51 am

  #152800

  I realize that this may be considered a hack or not best practices but I'd like to know if there was a way to alter the application that gets tagged to a SQL Server session.  When running a profiler trace I'd like the application to come up as something different for reporting reasons rather than Query Analyzer.  Is there any way to do this?

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  March 3, 2006 at 10:55 am

  #624682

  You would like to read an article of Andy Warren here on sqlservercentral.com:

  http://www.sqlservercentral.com/columnists/awarren/worstpracticebadconnectionstringsandbadinfoinsyspr.asp

  "Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses"

  it shows actually a good practice too including the application name. Not sure you can implement it for the third-party tool but you will be able to implement it for your connection strings.

  Regards,Yelena Varsha