We have a commerical application running on MS SQL 6.5. As you probably know, this is an very old verion of SQL that uses a "page locking" design which is more suseptible to lock-ups and "dead-lock" issues. Additionally, we have about twice the number of suggested users on the system than the manufacture recommends. Therefore, we have more than our share of system lock-ups. When this happens I have to load the Enterprise Manager and determine which user(process) is causing he problem by looking for any userID that shows a status of "blocking." I then use a right-click on the userID and next select the menu choice called "Kill the process." This releases the all of the other "blocked" users and the server returns to normal until the next episode.

My question is this: Is there a way to query this server using VFP9 and determine if any users(processes) are in the "blocking" status and then KILL that process intereactively via VFP.

The reason I want to handle this with VPF is that I'm not allowed to change anything on the corporate server (i.e., write any SP's etc.) but they do "toterate" me connecting to the server with FoxPro via and ODBC connection.

Thanks,
Robert