>SS 6.5, AFAIK, does support row level locking. I'm investigating this subject currently, so I don't have any concrete facts for you right now. I think the general scheme is that there is a lock escalation process that can cause you problems (and help n others, of course) with SS. I believe it is one of those behind-the-scenes approaches, and maybe your Oracle guy is referring to an explicit ability to control locking that SS does not have? There is a bit of a problem when the locks of 2 seperate processes are blocking each other, this could also be what your Oracle guy was talking about.
>
>I just picked up a copy of "The SQL Server 6.5 Performance Optimization and Tuning Handbook" by Ken England (ISBN: 1-55558-180-3, from amazon.com). It looks like it has a fairly good discussion of locking, but I haven't sunk my teeth into it yet.
>
>HTH,
>Scot.
The "ORACLE MAN" has left the building or shall we say he has "parted ways with the company". It looks like I'll be going with SQL Server after all !!!
AL
Al Williams
Anola MB, CANADA