No takers on this one? I didn't get any responses last week. Thank you in advance.
Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Callahan Sent: Thursday, April 29, 2004 2:40 PM To: [EMAIL PROTECTED] Subject: [IMail Forum] Enforcing User Quotas We are currently running IMail v.8.05 using an external user database. Not long after changing from the internal user database to an external, I ran into the problem of not being able to enforce user quotas. (i.e. Customer is allowed 25 mailboxes within their domain. The system will not stop them from adding 26 or more.) Ipswich tells me that, "that feature is not usable with an external db". Although, it seems silly to me that that number is not an exported value to the db, I began looking for a work-around. Sandy, here in the forum posted the following code as a work-around: CREATE TRIGGER QUOTA ON ODBC_DOMAIN_COM FOR INSERT AS IF (SELECT COUNT(*) FROM ODBC_DOMAIN_COM) > 100 ROLLBACK TRANSACTION GO ----------------- The issue I'm having now is determining how to implement this. It appears to me from the code that it is going to set one quota -- 100 in the example above -- to my main domain and all the virtual domains. I'm currently hosting mail for about 300 domains (in a virtual domain setup) and about 3500-4000 mailboxes. I need to be able to enforce user quotas on a per domain basis. If I'm misunderstanding the code above, could someone please explain how I should attack this or offer another solution if there is one? Thank you in advance. Mike To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
