For anyone that has not upgraded to SQL 7.0........
The entire process of upgrading took about 3 hours. Most of the time was
spent preparing for a disaster, which did not happen, but I felt a lot
better having multiple backups, and etc. While the server was down, I also
upgraded from 256mb to 512mb of memory and installed a Intel PRO/100 Server
adapter. I am sure the 512mb of ram helps and I know the Server adapter
works better as my remote tape back has a better throughput.
The end results is that a consolidation of 670,000 records went from taking
20+ hours to taking a little over 2 hours. And such things as Update Calls
now takes no more than 1-2 minutes instead of 1-2 hours.
So the short of it is, if you have not upgraded to 7.0 then you should do it
> -----Original Message-----
> From: email@example.com
> [mailto:firstname.lastname@example.org]On Behalf Of Dale E. Reed Jr.
> Sent: Sunday, November 07, 1999 11:40 AM
> To: email@example.com
> Subject: Re: [Emerald] VSA and USR's
> Ken Sorenson wrote:
> > Thanks for the attributes.. However, now I have the primary key
> issue with
> > the radattributes table. I know I have seen your response
> before, but it is
> > not in my archives. How do I modify the table to accept the inserts.
> The Primary Key for the RadAttributes table should be the
> RadVendorID, and RadVendorType attributes. The update script recreates
> the table with these keys. You can NOT just add the columns and change
> the primary key.
> Dale E. Reed Jr. Emerald and RadiusNT
> IEA Software, Inc. www.iea-software.com
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: