Sunday, March 11, 2012

Error: 1203

Query:
update entries
set item_convert_status=0,
item_code=key_cross_ref.item_code,
mida=key_cross_ref.mida,
zeva_default=key_cross_ref.zeva_default
from entries,key_cross_ref
where entries.company_code=1
and (ltrim(rtrim(entries.origin_barcode))=key_cross_ref.barcode or
entries.origin_item_code=key_cross_ref.barcode)
Somtimes i get 2 error logs:
--Error: 1203, Severity: 20, State: 1
--Process ID 53 attempting to unlock unowned resource PAG: 30:1:136319..
Someone?I found this article http://support.microsoft.com/?kbid=814654
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"msforums.mircosoft.com" <chen_sh@.hotmail.com> wrote in message
news:ePdozacbGHA.2456@.TK2MSFTNGP04.phx.gbl...
> Query:
> update entries
> set item_convert_status=0,
> item_code=key_cross_ref.item_code,
> mida=key_cross_ref.mida,
> zeva_default=key_cross_ref.zeva_default
> from entries,key_cross_ref
> where entries.company_code=1
> and (ltrim(rtrim(entries.origin_barcode))=key_cross_ref.barcode or
> entries.origin_item_code=key_cross_ref.barcode)
> Somtimes i get 2 error logs:
> --Error: 1203, Severity: 20, State: 1
> --Process ID 53 attempting to unlock unowned resource PAG: 30:1:136319..
> Someone?
>

No comments:

Post a Comment