Hi,

I use...

Wow, what a response!

I read some strange things in the previous reply.

When dealing with a shared transactual database with many differant user connections executing the same code that accesses the...

Hi,

There is a much easier solution for this problem:

alter table dbo.tbl_kvp

add constraint PK_tbl_kvp primary key(column_key);

go

Now not all rows are locked if you want to increment one key.

Only the...