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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problem in Enterprise Manager

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

Posted - 2011-05-15 : 16:01:16
What does sp_spaceused show?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-15 : 21:38:41
Are your client tools patched?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-16 : 21:41:04
You are incorrect. The client tool have bugs in them. You have to keep them up to date just like the engine.

The client tool updates are included in the regular engine updates.

So patch your 2000 client tools to the latest and retry.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -