If you're trying to keep your Calls table from getting cluttered with the
Start records, your best bet is to clear some out every night (automated
task) rather than prevent them from going into the system in the first
place. I have the following Scheduled Task set to run every night (very
early morning) that clears out any Start records and any null entries that
are over 3 days old:
DELETE FROM Calls
WHERE (AcctStatusType = 1 OR UserName = 'null')
AND DateDiff(Day, CallDate, GetDate()) > 3
Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart