Re: issue with AutoInc field and locks

1.. If it is possible try to avoid sequence autoinc in new developments,
since if some day you will decide to go 3 tiers disconnected mode it would
be general PITA. Use GUIDs instead, since they could be easily generated on
a client side
2.. I think that you can achieve exactly same effect if you will assign
Conection IsolationLevel to ilRepeatableRead and do select inside
transaction. But I should warn you that such design, i.e. usage of server
side cursors very badly affects performance in multi user environment. Could
you please elaborate what you are actually trying to achieve? Definitely
there should be better way.


.