Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    41

    Unanswered: SQL 2000 Enterprise Manager

    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.

  2. #2
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    Try "dbcc update usage" . This may help . I don't tend to use the GUI , and find sp_spaceused accurate

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •