Hi,

I'm in the process of writing a program that will automate the SQL Detach command so that I may copy their database to my system. My problem is that the Detach command will fail if there is users using it, for pretty obvious reasons, so I would like to know when the number of connections to the database is zero.

Perhaps there is another way.


TIA

Peter