CREATE TRIGGER QUOTA
ON ODBC_DOMAIN_COM
FOR INSERT
AS
IF (SELECT COUNT(*) FROM ODBC_DOMAIN_COM) > 100
   ROLLBACK TRANSACTION
GO

It works for me. Neither GUI throws an error (sometimes, non-verbosity
can be helpful!).

Sandy

___| Sanford Whiteman, Chief Technologist
___| Broadleaf Systems + Support, Inc.
___| mailto:[EMAIL PROTECTED]


Please visit http://www.ipswitch.com/support/mailing-lists.html 
to be removed from this list.

An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/

Please visit the Knowledge Base for answers to frequently asked
questions:  http://www.ipswitch.com/support/IMail/

Reply via email to