August 28, 2002 at 11:37 am
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
August 28, 2002 at 2:57 pm
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)
August 29, 2002 at 11:44 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply