how to set autogrowth off / on (T-SQL)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to set autogrowth off / on (T-SQL)

Author

Topic

ced
Starting Member

2 Posts

Posted - 2007-10-02 : 07:30:44

I am testing a msde 2000 sp4 database. (would like to use it against sqlserver 2005 later)
I need to turn the property for autogrowth on and check that an application alterts the user that it is on

and then off and verify the user is altered that it was set off.

I am not sure if this will work for mydb and mydblog
--turn off autogrowth
USE master
GO
ALTER DATABASE mydb
MODIFY FILE
(NAME = mydb,
FILEGROWTH = 0MB)
GO

--turn on autogrowth
USE master
GO
ALTER DATABASE mydb
MODIFY FILE
(NAME = mydb,
FILEGROWTH = 10MB)
GO

USE master
GO
ALTER DATABASE mydblog
MODIFY FILE
(NAME = mydblog,
FILEGROWTH = 0MB)
GO

--turn on autogrowth
USE master
GO
ALTER DATABASE mydblog
MODIFY FILE
(NAME = mydblog,
FILEGROWTH = 10MB)
GO

Also I need to know the t-sql for setting unrestricted growth on and off but I can not seem to find that.

Any help would be great.

We can not use enterprise manager so I'm planning to use osql thru a cmd prompt.

thanks
ced

Kristen
Test

22859 Posts

Posted - 2007-10-02 : 08:21:06

I think what you are looking for is:

MAXSIZE = UNLIMITED

Kristen

ced
Starting Member

2 Posts

Posted - 2007-10-02 : 15:58:27

thanks for the help
ced

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources