deadlock errors 1204 and 1205 differences

I believe there are 2 error numbers related to deadlocks 1204 and 1205. What
are the differences and when may i see one over another ? Using SQL 2000Hi
Error 1204 is issued when there is a process can not take out a lock rather
than the process being deadlocked. This is a resource problem and the number
of locks can be increased using sp_configure.
See Books Online:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\trb
lsql.chm::/tr_reslsyserr_1_6gxg.htm
Error 1205 is issued when a deadlock is detected. Check out "Inside SQL
Server 2000" by Kalen Delany ISBN 0-7356-0998-5 on how to detect and solve
deadlock problems.
John
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:utZq8LR%23DHA.1632@.TK2MSFTNGP12.phx.gbl...
> I believe there are 2 error numbers related to deadlocks 1204 and 1205.
What
> are the differences and when may i see one over another ? Using SQL 2000
>

deadlock errors 1204 and 1205 differences

I believe there are 2 error numbers related to deadlocks 1204 and 1205. What
are the differences and when may i see one over another ? Using SQL 2000Hi
Error 1204 is issued when there is a process can not take out a lock rather
than the process being deadlocked. This is a resource problem and the number
of locks can be increased using sp_configure.
See Books Online:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\trb
lsql.chm::/tr_reslsyserr_1_6gxg.htm
Error 1205 is issued when a deadlock is detected. Check out "Inside SQL
Server 2000" by Kalen Delany ISBN 0-7356-0998-5 on how to detect and solve
deadlock problems.
John
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:utZq8LR%23DHA.1632@.TK2MSFTNGP12.phx.gbl...
> I believe there are 2 error numbers related to deadlocks 1204 and 1205.
What
> are the differences and when may i see one over another ? Using SQL 2000
>

DBname (loading)

We attempted to restore a database to a new name via EM (2000) and it
errored. Now, in the database list it shows as "(Loading...)".
I believe restarting the instance will clear it, but I was wondering if
there is a way to clear it that doesn't involve a restart.You can simply drop it or restore over it.
"Jay" <nospan@.nospam.org> wrote in message
news:OkVP$3XHIHA.3548@.TK2MSFTNGP06.phx.gbl...
> We attempted to restore a database to a new name via EM (2000) and it
> errored. Now, in the database list it shows as "(Loading...)".
> I believe restarting the instance will clear it, but I was wondering if
> there is a way to clear it that doesn't involve a restart.
>|||Thank you sir.
"YPD" <y.ding@.neu.edu> wrote in message
news:EA65B23A-789A-4B6E-A780-1FBDC5D7BC08@.microsoft.com...
> You can simply drop it or restore over it.
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:OkVP$3XHIHA.3548@.TK2MSFTNGP06.phx.gbl...
>> We attempted to restore a database to a new name via EM (2000) and it
>> errored. Now, in the database list it shows as "(Loading...)".
>> I believe restarting the instance will clear it, but I was wondering if
>> there is a way to clear it that doesn't involve a restart.
>