SP_DBOPTION or ALTER DATABASE - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Administration (2000)

SP_DBOPTION or ALTER DATABASE

Author

Topic

cgunner
Yak Posting Veteran

95 Posts

Posted - 2005-08-14 : 10:09:11

I was wondering how you uncheck a selection. In database properties, Data Files tab, File Properties, Automatically grow file what command would you use to uncheck that box threw Query Analyzer?

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-08-14 : 10:52:09

USE master;
GO
ALTER DATABASE mydatabase
MODIFY FILE
(NAME = myfilename,
FILEGROWTH = 0);
GO

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

cgunner
Yak Posting Veteran

95 Posts

Posted - 2005-08-17 : 09:30:18

Thanks Paul.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources