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 |
|
boz
Starting Member
3 Posts |
 Posted - 2001-12-14 : 12:32:25
|
| I tried the work around that microsoft recomended to resolve this by doing a recalculate and then run Checkpoint and then they say the Database size should be fixed at the moment it is showing 0mb |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-14 : 13:47:30
|
| This may sound overly simplistic, but sometimes in Enterprise Manager I have to do a REFRESH or Exit out and come back in to it in order to see the updated results.-------------------It's a SQL thing... |
 |
|
|
boz
Starting Member
3 Posts |
Posted - 2001-12-15 : 10:33:20
|
I tried the fix that Microsoft recommends but it still does not work?BUG: SQL Enterprise Manager Displays Negative or 0 Database Size (Q169347)--------------------------------------------------------------------------------The information in this article applies to:Microsoft SQL Server versions 6.0 , 6.5 --------------------------------------------------------------------------------BUG #: 10248 (6.0) 13149 (6.5)SYMPTOMSThe Edit Database window of SQL Enterprise Manager (SEM) reports the database space available or log space available as a value less than or equal to 0 when free space is actually available. This problem occurs even after you use the Recalculate button to recalculate the amount of free space. WORKAROUNDTo work around this problem, use the Recalculate button and then run the CHECKPOINT command in the database. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. --------------------------------------------------------------------------------Published Jun 5 1997 5:18PM Issue Type kbbug Last Modifed Mar 12 2000 9:49AM Additional Query Words Keywords kbusage kbSQLServ650bug ![]() |
|
|
|
|
|
|
Bug # 13149 SQL recalculate database