|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > Error 1203:
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| rjrlane 2002-08-06, 12:23 pm |
| I just received this error:
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource KEY: 13:117575457:2
We are running SQL7.0 SP2 on ML570 quad 900mz w/ 1gb RAM.
I have read http://support.microsoft.com/defaul...b;en-us;Q240853
and we are testing SP3 right now. I was wondering does anybody know of any
traceflags I can set to capture more information in the error log as to what
was running when/if the error happens again. Thanks in advance.
-Bob-
| |
| Erland Sommarskog 2002-08-06, 5:23 pm |
| rjrlane (rjrlane@aol.com) writes:
> I just received this error:
> spid7 Error: 1203, Severity: 20, State: 1
> spid7 Process ID 7 attempting to unlock unowned resource KEY:
> 13:117575457:2
> We are running SQL7.0 SP2 on ML570 quad 900mz w/ 1gb RAM.
>
> I have read
> http://support.microsoft.com/defaul...b;en-us;Q240853 and we
> are testing SP3 right now. I was wondering does anybody know of any
> traceflags I can set to capture more information in the error log as to
> what was running when/if the error happens again. Thanks in advance.
The number 117575457 you can translate in sysobjects of the concerned
database. I would guess its the database with dbid = 13.
I don't think there are traceflags to catch this. Basically, this an
error that should not occur.
SP3? SP4 for SQL7 is out.
--
Erland Sommarskog, SQL Server MVP
sommar@algonet.se
Books Online (updated!) for SQL 2000 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|
|
|
|
|