At 11:03 PM 12/10/97 -0800, you wrote:
>On Wed, 10 Dec 1997, Michael Whisenant wrote:
>
>> >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
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>