How to enable tablespace auto-extend

How do I enable tablespace auto-extending in MSDE 2000?We don't use the term "tablespace" in SQL Server, so you need to define what
you mean by it. If you
mean the file, then you can control this by setting the max size larger than
the current size and
specify how much for the file to grow on each occasion.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Zoal" <Akone@.hotmail.com> wrote in message news:eEc2c0F0HHA.5948@.TK2MSFTNGP03.phx.gbl...[vb
col=seagreen]
> How do I enable tablespace auto-extending in MSDE 2000?
>[/vbcol]|||What is the sql command to set the max size.
Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:549C41AF-0E30-479D-B99F-67198E2DE72B@.microsoft.com...
> We don't use the term "tablespace" in SQL Server, so you need to define
> what you mean by it. If you mean the file, then you can control this by
> setting the max size larger than the current size and specify how much for
> the file to grow on each occasion.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Zoal" <Akone@.hotmail.com> wrote in message
> news:eEc2c0F0HHA.5948@.TK2MSFTNGP03.phx.gbl...
>|||> What is the sql command to set the max size.
Please see ALTER DATABASE in Books Online.
ALTER DATABASE Database_Name
MODIFY FILE
(
NAME = logical_file_name,
MAXSIZE = 2000MB
);
GO
However with MSDE the max size is 4GB anyway...
Aaron Bertrand
SQL Server MVP