April 10, 2003 at 9:26 am
I'm querying across 2 db's and consistantly recieve this message :
Is there anybody who can give me a lead?
-DBcc reports no errors on either of the databases.
thks
Actual message:
--******************
Server: Msg 1203, Level 20, State 1, Line 1
Process ID 53 attempting to unlock unowned resource PAG: 7:1:29876.
--******************
Connection Broken
April 10, 2003 at 9:30 am
April 10, 2003 at 9:35 am
Can you post your query too? Do you see any errors in your SQL Server errorlog? Which version and service pack do you have for SQL Server?
April 11, 2003 at 5:19 am
Sorry - lack of detail: SQL 2000 SP3 one processor selected.
My problem's sorted now - there seemed to be an issue on one of the inner joins.
Little mysterious as the same query performed perfectly on the prod server
Thks for all the suggestions !
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply