Re: Need Locking Edification

Cosmo Lee wrote: > > We're having a problem that when we are running deletes from a table, > users are locked out from completing Selects, and Inserts fail. We > can't quite figure out why this happens . . . > Two comments: firstly, "edification" means "praise." I think you meant to use the word "clarification." Secondly, tables are created by default with page-mode locking wherein a complete page is locked rather than an individual row. If this is the case (use the -ss option of dbschema, for example), then change it to row locking instead. -/Renegade