Unable to change SQL 2005 database Autogrowth through Server Management Studio

I have a database that seems to change its autogrowth settings every so often. When I initially set this up, I set the autogrowth at 500MB. After some time, I noticed that the autogrowth was set to 645000%. When I tried to change it through Management Studio but recieve the following error

' Value of '645000' is not valid for 'Value'. 'Value should be between 'Minimum and Maximum'.

Parameter name: Value(System.Windows.forms)

This occurs when I try to open it in order to change it. The only way to change it is through Transact.

USE master
GO
ALTER DATABASE mydb 
MODIFY FILE
  (NAME = mydb_data,
  FILEGROWTH = 500MB)
GO

This will work, but for how long I do not know. I have done this twice before.

The first problem is why am I unable to change this value using SQL Management Studio. Second is why is this value being changed and how does such a large value get inputted.

So far, this is only happening with only one of my 2005 database. Any direction would be of great help.

Thanks

Akinja Richards

Terrence

Thanks for the follow up. After a few days, it doesn't seem to have reoccurred but that doesn't mean it will not. I have been keeping an eye on it an hopefully can track down why this may have happened.

Akinja

Same issue here, occurring on an install that went directly to v9.0.3054, before having loaded the databases. It appears that by the time of the first major growth opportunity, the autogrowth went to 2650% and database size jumped from about 1.6GB to just about 40GB, consuming virtually all free space on the partition.

-- Cornell Hooton

We are currently running SP2. This issue happened again over the weekend to 4 of the databases on one of our servers. The new percentage growth for all of them was 65000+ %.

This is happening a lot LESS in SP2 but it's still happening to us... Is there going to be another bug fix coming