General information
Forum:
Microsoft SQL Server
Title:
Discovering details of a transaction
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only