Corrupt auto grow value.

I went in to look at the properties on a database and the autogrow was set
to 12800 percent. I obviously didn't set it to this ( I usually do something
like 10MB ). But now I can't get in to change the value - it tells me the
value is to big.

How can I change it?

TIA - Jeff.

let me guess...SQL 2005, pre-Sp2?

let me guess...SQL 2005, pre-Sp2?  Known bug fixed in SP2.  I *think* it had
to do with databases that were migrated from 2000 or the servers were
upgraded.

Where are you trying to change the value...the GUI or a T-SQL statement?

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

Corrupt auto grow value.

Jeff,

Use TSQL as follows:

ALTER DATABASE MyDatabase MODIFY FILE
(NAME = N'MyDatabase_Log', FILEGROWTH = 10240KB)

RLF

Correct on all accounts.

Correct on all accounts. This database (and others) came from 2000 through
2005 and I just installed the SP2 on Tuesday night.

I have tried through the GUI.

TIA - Jeff.

Corrupt auto grow value.

Thanks. That worked great.

Did you apply the CORRECT sp2?

Did you apply the CORRECT sp2?  It was rereleased a few times.  It also has
a mandatory GDR2 update as well as 5 (soon to be 6) cumulative update
patches.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net