Is there a function in SQL 7.0 that will tell you if someone left a connection object open or not? I have people using my SQL 7.0 and Access 2000 database off the server and sometimes they leave the connection object open and it is using up my memory. So I was thinking of some way to check within SQL to see if someone is leaving open a connection to a database they are using.
