Hello gurus:

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.

Any help would be greatly appreciated.

Thanks,

CTBlankenship