Posted by David Portas on 02/01/06 12:45

You can put a table in a filegroup and set the file(s) in that group to
a fixed size. Take a look at the ON filegroup clause of the CREATE
TABLE statement and also the ALTER DATABASE filegroup options.

You can also logically restrict a table to some maxium number of rows

CREATE TABLE t1 (... x INTEGER NOT NULL UNIQUE CHECK (x BETWEEN 1 AND
10000), ...)

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]