thanks, Marek.

I agree with you that this (key_generator) is not optimal design, but I have inherited the problem, and can't change it! The sql line which you said looked strange...

Helps a lot, and thanks very much!

Yes, the primary key is non-clustered. It sounds like if I 1) make this a clustered key, and 2) issue my select WITH UPDATE, that since I only pull one...

Ran the select, and indid = 2 is for the primary key on the table (indid = 0 is for the table, and there is no indid = 1). There...

Thanks, Karl, that makes sense. The only index on this table is on kg_table_id, a column which never gets updated. So how would I generate an exclusive lock on the...

Thanks for your reply! That is pretty much how I see it, too. My question then becomes: how can both an X and a U be granted on the same...