Hi, I was wondering if anybody has ever had a problem with blocking and the sp_unprepare statement. We have an application that is inserting data into a table and the process will freeze until we kill spid executing the sp_unprepare statement because it is blocking another spid. We have just recently upgraded to SP2 could this be the problem?
View 1 RepliesHi,
We are having problems with those two procedures, they are blocking other processes. I have seen sp_prepexec block another process for 5 hours, beforeI finally killed the process and the blocked process executed. Has anyone experienced behavior like this? What else can I do to troubleshoot this and determine the issue that is causing this? We could really use some assistance to determine the root of the problem.
Thanks.