| Subject | limit rows in a table | 
|---|---|
| Author | newgen_315 | 
| Post date | 2005-08-25T14:54:47Z | 
Hi all,
Could someone please suggest how I can limit the amount of rows a
user
can enter in a table, using a Stored Procedure or a trigger.
I would like to limit the amount of rows to 1K, and all new inserts
would be stopped/cancelled from this point on.
How should I accomplish this?
Thanks
Daniel
            Could someone please suggest how I can limit the amount of rows a
user
can enter in a table, using a Stored Procedure or a trigger.
I would like to limit the amount of rows to 1K, and all new inserts
would be stopped/cancelled from this point on.
How should I accomplish this?
Thanks
Daniel