Results 1 to 2 of 2

Thread: sp_unprepare

  1. #1
    Care Guest

    sp_unprepare


    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?

  2. #2
    Join Date
    Oct 2005
    Posts
    1

    You are no alone

    I got the same error with SQL Server 2000 and the worst it only happens in the client site...!

    Somebody could give us a hint...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •