First, run the instindx.sql script on your database from Emerald
2.5 to make sure you have all the indexes for the calls table.
Secondly, run the latest checkdb.sql script, to make sure the
stats on your indexes are up to date.
The key on the CallHistory table is too restrictive, if you are doing
any usage billing. You can use Enterprise manager to remove the key
and it should allow the records to be inserted correctly. All you
need on the CallHistory table is a duplicates allowed index on the
AccountID (which you should already have).
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html