Hi Charles,

You can use sp_who and undocumented sp_who2 system stored procedures to get the list of all connections.
As last resort, you can use SQLDISCONNECT(0) to close all ODBC connections in a VFP applications.
VFP9 has new function ASQLHANDLES() that retrieves information for all active SQL connection statement handles.

>In SQL Server Enterprise Manager if you select Detach Database from the All Tasks popup of the database you want to manage a dialog appears that identifies the number of connections currently active on that database. If you press the OK button while the connection count is 1 or greater another dialog appears that asks "Do you want to notify the user that their connection is about to be terminated" (or something close to that). If the administrator chooses to notify the people using the connection, the client machine receives one Windows notification (messagebox in VFP vernacular) for each connection their machine is using. In my case, however, if the connection count is four (as an example) I receive only three messages. This in and of itself is not a "problem" per se ... it is only one of the symptoms. Another symptom is that after closing the application in the VFP development environment, SQL Server still says my client development machine has an open connection. The
>connection is only released after VFP itself is shut down. For the life of me I cannot find where this connection originated and therefore, cannot figure out how to close it down. This one little problem, with one hundred users, will eat up connections quite quickly. Therefore, I needed to know how to discover information about open connections from the SQL Server side of the equation vice from within the VFP Development Environment side.
>
>So, in conclusion, are their any stored procedures or SQL Server functions that detail all of the information about the active connections within the SQL Server domain?
>
>Thanks for taking the time to work through this long post and sorry for not being clearer on my original one.
>
>CT