Data File Did Not Automatically Grow

I have a data file that is set to automatically grow 10%. 11858 MB was allo
cated to the database, whose max growth was set to 15000 MB. There was 0 MB
space free for about an hour. I had to go into Enterprise Manager and chan
ge the space allocated from
11858 MB to 13000 MB and the data file grew fine.
I don't understand why it didn't automatically grow. All of our databases a
re set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
Has anyone seen this issue before?
Thank you very much for your time.
MelanieSometimes autogrow doesn't catch up, quite simply. We see this from time to
time, and I've seen at least one technical description for a scenario where
this can happen (but I don't recall details). There might be KB articles
about specific scenarios, but fact still stand...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Melanie" <anonymous@.discussions.microsoft.com> wrote in message
news:C6D5E793-85CB-4345-93BB-5FBAC9AD028D@.microsoft.com...
> I have a data file that is set to automatically grow 10%. 11858 MB was
allocated to the database, whose max growth was set to 15000 MB. There was
0 MB space free for about an hour. I had to go into Enterprise Manager and
change the space allocated from 11858 MB to 13000 MB and the data file grew
fine.
> I don't understand why it didn't automatically grow. All of our databases
are set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
> Has anyone seen this issue before?
> Thank you very much for your time.
> Melanie

Data File Did Not Automatically Grow

I have a data file that is set to automatically grow 10%. 11858 MB was allocated to the database, whose max growth was set to 15000 MB. There was 0 MB space free for about an hour. I had to go into Enterprise Manager and change the space allocated from 11858 MB to 13000 MB and the data file grew fine
I don't understand why it didn't automatically grow. All of our databases are set to auto grow and we have never had this problem. There is 8 GB free on the drive that the data file resides
Has anyone seen this issue before
Thank you very much for your time
MelanieSometimes autogrow doesn't catch up, quite simply. We see this from time to
time, and I've seen at least one technical description for a scenario where
this can happen (but I don't recall details). There might be KB articles
about specific scenarios, but fact still stand...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Melanie" <anonymous@.discussions.microsoft.com> wrote in message
news:C6D5E793-85CB-4345-93BB-5FBAC9AD028D@.microsoft.com...
> I have a data file that is set to automatically grow 10%. 11858 MB was
allocated to the database, whose max growth was set to 15000 MB. There was
0 MB space free for about an hour. I had to go into Enterprise Manager and
change the space allocated from 11858 MB to 13000 MB and the data file grew
fine.
> I don't understand why it didn't automatically grow. All of our databases
are set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
> Has anyone seen this issue before?
> Thank you very much for your time.
> Melanie

Data Field not Truncating

I have a data field in my report that needs to truncate when it is too long. I do not have "Can Grow" checked, but this field will still run over and interrupt other data.
I cannot reposition this field so it won't interrupt anything else.
Thanks for any help.If the filed has too many characters without a space this may happen. To avoid this create a formula @.MyField having the code
mid(Field,1,20)So only 20 charaters will be printed