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?http://support.microsoft.com/?kbid=814654
Immy
"msforums.mircosoft.com" <chen_sh@.hotmail.com> wrote in message
news:ukjIEbcbGHA.1272@.TK2MSFTNGP03.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?
>|||I have SP3 installed.
Which hotfix do i need?
Is it safe enough to install SP4 ?
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:%23gljLdcbGHA.3380@.TK2MSFTNGP04.phx.gbl...
> http://support.microsoft.com/?kbid=814654
> Immy
> "msforums.mircosoft.com" <chen_sh@.hotmail.com> wrote in message
> news:ukjIEbcbGHA.1272@.TK2MSFTNGP03.phx.gbl...
>|||Well obviously you should test the SP4 before installing it for live,
however, SP4 is in wide use by many people with no major issues.
I have SP4 on all my live servers, but that's not to say that you HAVE to
install it purely based on my example.
I assume this fix will be in the Sp4 but you should check the SP4 Checklist
to confirm it is.
If not, you may need to speak to MS directly to obtain the hotfix.
Immy
"msforums.mircosoft.com" <chen_sh@.hotmail.com> wrote in message
news:eB6G8lcbGHA.4672@.TK2MSFTNGP04.phx.gbl...
>I have SP3 installed.
> Which hotfix do i need?
> Is it safe enough to install SP4 ?
> "Immy" <therealasianbabe@.hotmail.com> wrote in message
> news:%23gljLdcbGHA.3380@.TK2MSFTNGP04.phx.gbl...
>