What connection atributes are you looking for?

>
>How can one use SQL syntax to discover the attributes of a connection? The lumbering way I'm discovering the number of remaining connections (after shutting down the client app) is to begin a Detach Database action via Enterprise Manager.
>
>Normally, when I tell it to clear all connections, SQL Enterprise Manager asks if I want to notify those who are about to loose connection. When I choose yes my development machine receives a warning dialog for all open connections ... except one. It is that one whose characteristics I am trying to discover.
>