Hi,

My application using foxpro sometimes seems like hang and when connect to sql server. I directly go to the sql server and use sp_lock to check whether there is any thread is waiting and i use sp_who and can see one process got blocking. But these things not happen in foxpro database. How i need to troubleshoot this problem, what i can do so that i can prevent from blocking/deadlock. I have a profiler and the profiler save the procedure. So, how i can check and provent by using this profiler?

Thanks a lot.

regards,

florence