Microsoft KB Archive/175412
Article ID: 175412
Article Last Modified on 10/3/2003
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q175412
BUG #: 16781 (NT: 6.5)
If a database is created with a log size of over 2 GB, the Edit Database dialog box in SQL Enterprise Manager may incorrectly report Log Size as zero.
To work around this problem, use the following query to return the log size in MB for the database:
select (sum(size)/512) from master..sysusages where dbid = db_id('<database_name>') and segmap = 4
Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Additional query words: SEM disk space free 0
Keywords: kbbug kbenv KB175412