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.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-05-15 : 13:14:23
|
Hi,
I have scenario where in the SQL Server 2000 Enterprise Manager shows up "Space Avialable" = 0.0MB.
There is sufficient space at OS level.
I really dont have any clue. In sql server ERROR log, nothing is logged.
Thought it is something autogrowth problem. I manually increased 512 mb for the data file and again it was working.
My SQL 2000 is on SP3 service pack level?
why GUI shows 0.0MB as space available?
Is this a known issue or what does it mean and what all scenario's Enterprise manager will show up as 0.0 MB.
Any help would be greatly appreciated.
Thanks in Advance.
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2011-05-15 : 20:05:57
|
if i use the cmd sp_helpdb then
sp_helpdb 'db'
It is showing lot of space, but dont have idea why GUI shows 0mb.
no error like could not alloate space in ERRORLOG.
Strange. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2011-05-16 : 20:58:46
|
Hi Tara,
How does my tools getting patched makes a difference??
Moreover, i dont think there an option in sql 2000 to update tools only while appyling patch.
Thanks in advance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2011-05-16 : 22:06:32
|
Hi Tara,
Thanks for the correction.
It is giving an option for choosing tools as well.
|
|
|
|
|
|
|
Problem in Enterprise Manager