Enterprise manager reporting Free Space

I 'm running sql server 2k, with service pak3a, Win2k with lastest service
pak. We have a database that shows as being 9gig, with 0.00 MB free when
looking at the properties of it in Enterprise manager. The hdisk where that
database resides has 45gig free, with no disk quotes. Also, the database is
set to auto grow by 10%, both the tran log and data file. I have no idea why
it's not seeing more the 0.00mb free...any thoughts or ideas would be
greatly appreciated..
-Bob
That reports the space free in the MDF file, not on the drive.
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> pak. We have a database that shows as being 9gig, with 0.00 MB free when
> looking at the properties of it in Enterprise manager. The hdisk where
that
> database resides has 45gig free, with no disk quotes. Also, the database
is
> set to auto grow by 10%, both the tran log and data file. I have no idea
why
> it's not seeing more the 0.00mb free...any thoughts or ideas would be
> greatly appreciated..
> -Bob
|||how can I increase that space...do i need to?
"Aaron [SQL Server MVP]" wrote:

> That reports the space free in the MDF file, not on the drive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> that
> is
> why
>
>
|||If you have it set to autogrow, it will increase the space when it needs to.
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:8C9B48B3-4737-4A2C-A21F-A7A9095154DC@.microsoft.com...[vbcol=seagreen]
> how can I increase that space...do i need to?
> "Aaron [SQL Server MVP]" wrote:
service[vbcol=seagreen]
when[vbcol=seagreen]
database[vbcol=seagreen]
idea[vbcol=seagreen]