Error 1203

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  August 28, 2002 at 11:37 am

  #105513

  Hello:

  I tried to run a SELECT statement and got the following error message.

  "Server: Msg 1203, Level 20, State 1, Line 1

  Process ID 55 attempting to unlock unowned resource PAG: 7:1:33028.

  Connection Broken"

  BOL tells me to run DBCC CHECKDB against that database. I did that but the error message is still there. Can anyone shed any light on this?

  Thanks in advance,

  Billy

• Antares686

  SSC Guru

  Points: 125444

  More actions

  August 28, 2002 at 2:57 pm

  #435565

  Take a look here and see if does not work http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q240853&

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  August 29, 2002 at 11:44 am

  #435687

  Thanks for the KB. SS2K was not shutting down but I think that the problem might have something to do with multiple threads.

  The sql statement I was trying to run contained many nested sql statements; running each of those sql statements individually went smoothly but the error message will come up if you combine them all into one gigantic sql statement.

  The solution I came up with was to break up those nested sql statements and use a temporary table to store the results I wanted to see.

  Billy