Do you have any Service Packs on your SQL Server? In the Emerald
Help...About, what version does it say your SQL Server is? There are
known problems with SQL Server pre SP3 that can cause problems,
including crashing your SQL Server.
> I have some other problems too:
> - Can i install a task that runs monthly and automtically deletes all
> entries in the calls table older than xxx months?
Yes. You'll coonfigure a TSQL to execute something like:
Delete from Calls where DateDiff(Month, CallDate, GetDate) > xxx
> - Because we use this program in Germany we would like to use other currency
> and date formats:
> $ --> DM
> MM/DD/YYYY --> DD/MM/YYYY
> If i change my regional settings to this formats i get SQL errors with
> Emerald. Is this a problem with the SQL server or does Emerald not support
> other currency and date formats? We currently use a US version of SQL server
> 6.5. Is it possible to get Emerald running when we change to a german
Emerald 2.5 resolves most of these issues. You must have SP3 or higher
installed not only on your server, but also on your clients, as it
addresses issues with international settings.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html