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 thensp_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