Hi all,

Is this legal ?

SELECT a.col1,b.col2,c.col3
FROM tab1 a WITH (UPDLOCK) , tab2 b, tab3 c
WHERE a.col1 = b.col1
and b.col2 = c.col1

WIll the above cause a UPDLOCK on tab1 and not tab2 and tab3?

COmments,thoughts,criticisms?

I have a problem with a query that performs a multi-table join
to get column values and then one of the tables in the join is
being updated. I am getting DEADLOCKs and was wondering if I could
try and reduce that.

Also how can I find out what locks are in effect for a certain
query..Is it syslocks or are there any other tables..?

DrD