Tagging a connection for profiler

[Luke Wright]

Hi,
We have a .NET application using connection pooling. What we would like to
be able to do is somehow associate a connection with a session id (an id used
by our application to represent a login session) for the duration of each
command issued on behalf of the session. This would allow us to filter on
this id in SQL Server Profiler in order to monitor all actions associated
with a specific session, ignoring the many other sessions that are
simultaneously hitting the server.

We thought about using the application name for this purpose (embedding the
session id in it), but this will cause connection pooling to never reuse
connections.

We poked around in SQL Server Profiler and didn't see any columns in the
filter options that might be used for this purpose.

Thanks for your help,
Luke Wright
Projector PSA, Inc.