> >Most likely the issue was the size of your tempdb, not the locks.
> >I ran into an issue here today where I was doing a consolidation on
> >about 800,000 records, and it kept telling me I was out of locks, but
> >I didn't beileve it. After raising the size of tempdb to 40mb (from
> >20mb) it ran fine.
>
> But as your know my tempdb was increased as a measure to solve this to
> 300mb already. Therefore I am unclear about this?
Emerald just doesn't use that many locks for consolidation. The one
thing I would like to try and see is if its a database issue. I've
seen a lot of problems disappear by do an SQL transfer of the data
into a new database (especially page allocation problems). If you want
me to give that a test let me know.
Dale E. Reed Jr. (daler@iea.com)
_________________________________________________________________
IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
Internet Solutions for Today | http://www.iea-software.com