Connection pool doesn't register program name

• praveen_vejandla

  SSCrazy

  Points: 2069

  More actions

  November 3, 2011 at 6:09 am

  #74679

  Hi,

  If I am using a connection pool, is there a way to log different application name in master..sysprocesses each time an application uses a connection from connection pool.

  By setting Application Name property, all the pooled connections are showing same program name in master..sysprocesses.

  Is there a way to pass program name while re-using a connection from connection pool?

  Thanks.

• SQLALX

  SSC Eights!

  Points: 956

  More actions

  December 5, 2011 at 6:11 pm

  #1417086

  AFAIK, Connection pooling is based on exact match of connection string.

  If you use different application name, new connection pool will be created.

  I think this is by design.