Locks
in [Programming SQL]
|
Prev: Check Reporting Services Installation Programmitcally
Next: TransactionAbortedException Occurs Randomly
From: Marek on 22 Jul 2008 06:23 On Jul 22, 11:35 am, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Marek > There are many objects (72057594043498496,72057594043432960 ) can show us by > using OBJECT_NAME... to what table/index does it relate? > > Again, do you have index on do? or oscislo ? Clustered Index might be a good > candidate 'datum' column > > "Marek" <gro...(a)volny.cz> wrote in message > > news:a8d30c62-fac4-4170-bea7-f7a36aca4c30(a)b1g2000hsg.googlegroups.com... > > > > > why > > delete from do_kumulace WITH (ROWLOCK) where oscislo = 501212 and > > convert(datetime,'01.03.2007',104) <= do and > > convert(datetime,'31.03.2007',104) >= od > > blocking this command ? > > delete from do_intervaly WITH (ROWLOCK) where oscislo = 501070 and > > convert(datetime,'17.09.2007',104) <= datum and > > convert(datetime,'23.09.2007',104) >= datum > > > ?- Hide quoted text - > > - Show quoted text - how I get information about object 72057594043498496 ?
From: Uri Dimant on 22 Jul 2008 08:06 Marek OBJECT_NAME functions takes a parameter objectid SELECT OBJECT_NAME (72057594043498496) "Marek" <grolms(a)volny.cz> wrote in message news:850bccba-2df7-4b2b-b424-498883f30711(a)x35g2000hsb.googlegroups.com... On Jul 22, 11:35 am, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Marek > There are many objects (72057594043498496,72057594043432960 ) can show us > by > using OBJECT_NAME... to what table/index does it relate? > > Again, do you have index on do? or oscislo ? Clustered Index might be a > good > candidate 'datum' column > > "Marek" <gro...(a)volny.cz> wrote in message > > news:a8d30c62-fac4-4170-bea7-f7a36aca4c30(a)b1g2000hsg.googlegroups.com... > > > > > why > > delete from do_kumulace WITH (ROWLOCK) where oscislo = 501212 and > > convert(datetime,'01.03.2007',104) <= do and > > convert(datetime,'31.03.2007',104) >= od > > blocking this command ? > > delete from do_intervaly WITH (ROWLOCK) where oscislo = 501070 and > > convert(datetime,'17.09.2007',104) <= datum and > > convert(datetime,'23.09.2007',104) >= datum > > > ?- Hide quoted text - > > - Show quoted text - how I get information about object 72057594043498496 ?
From: Marek on 22 Jul 2008 09:49 On Jul 22, 2:06 pm, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Marek > OBJECT_NAME functions takes a parameter objectid > SELECT OBJECT_NAME (72057594043498496) > > "Marek" <gro...(a)volny.cz> wrote in message > > news:850bccba-2df7-4b2b-b424-498883f30711(a)x35g2000hsb.googlegroups.com... > On Jul 22, 11:35 am, "Uri Dimant" <u...(a)iscar.co.il> wrote: > > > > > > > Marek > > There are many objects (72057594043498496,72057594043432960 ) can show us > > by > > using OBJECT_NAME... to what table/index does it relate? > > > Again, do you have index on do? or oscislo ? Clustered Index might be a > > good > > candidate 'datum' column > > > "Marek" <gro...(a)volny.cz> wrote in message > > >news:a8d30c62-fac4-4170-bea7-f7a36aca4c30(a)b1g2000hsg.googlegroups.com... > > > > why > > > delete from do_kumulace WITH (ROWLOCK) where oscislo = 501212 and > > > convert(datetime,'01.03.2007',104) <= do and > > > convert(datetime,'31.03.2007',104) >= od > > > blocking this command ? > > > delete from do_intervaly WITH (ROWLOCK) where oscislo = 501070 and > > > convert(datetime,'17.09.2007',104) <= datum and > > > convert(datetime,'23.09.2007',104) >= datum > > > > ?- Hide quoted text - > > > - Show quoted text - > > how I get information about object 72057594043498496 ?- Hide quoted text - > > - Show quoted text - I want try this , but in this table not object id .... SELECT resource_type, resource_description,resource_associated_entity_id, request_mode, request_status FROM sys.dm_tran_locks WHERE resource_associated_entity_id > 0
From: Marek on 22 Jul 2008 09:53 On Jul 22, 2:06 pm, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Marek > OBJECT_NAME functions takes a parameter objectid > SELECT OBJECT_NAME (72057594043498496) > > "Marek" <gro...(a)volny.cz> wrote in message > > news:850bccba-2df7-4b2b-b424-498883f30711(a)x35g2000hsb.googlegroups.com... > On Jul 22, 11:35 am, "Uri Dimant" <u...(a)iscar.co.il> wrote: > > > > > > > Marek > > There are many objects (72057594043498496,72057594043432960 ) can show us > > by > > using OBJECT_NAME... to what table/index does it relate? > > > Again, do you have index on do? or oscislo ? Clustered Index might be a > > good > > candidate 'datum' column > > > "Marek" <gro...(a)volny.cz> wrote in message > > >news:a8d30c62-fac4-4170-bea7-f7a36aca4c30(a)b1g2000hsg.googlegroups.com... > > > > why > > > delete from do_kumulace WITH (ROWLOCK) where oscislo = 501212 and > > > convert(datetime,'01.03.2007',104) <= do and > > > convert(datetime,'31.03.2007',104) >= od > > > blocking this command ? > > > delete from do_intervaly WITH (ROWLOCK) where oscislo = 501070 and > > > convert(datetime,'17.09.2007',104) <= datum and > > > convert(datetime,'23.09.2007',104) >= datum > > > > ?- Hide quoted text - > > > - Show quoted text - > > how I get information about object 72057594043498496 ?- Hide quoted text - > > - Show quoted text - Arithmetic overflow error converting expression to data type int.
First
|
Prev
|
Pages: 1 2 3 Prev: Check Reporting Services Installation Programmitcally Next: TransactionAbortedException Occurs Randomly |