Post reply

Change application name in SQL Server session

  • 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?

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply