The easiest way I know how to do this is:
1. Open ip SQL Enterprise Manager.
2. Connection to your SQL Server, drill down to Emerald,
Objects, tables, calls. Right click over calls and drop
the calls table.
3. Open up the query tool from within SQLEW. Load insttabs.sql
in. Find the "Create Table Calls" line, go a couple down, and
change the AcctSessionID field size varchar(10) to varchar(18)
or whatever you need.
4. Hightlight the lines starting from create table calls down
to the closing ). Click the green arrow (execute).
5. Load in and execute the insttrig.sql and instperm.sql scripts.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com