I had the same thought exactly, and yes, they ARE differerent. In fact, I see where the error messages I mentioned in my previous note are coming from, as there is a new section of information between the general info and the device usage section. The free space on the logsegment is "not applicable", so it would be problematical parsing out information that just does not exist (at least with the ASE 12.0 version of sp_helpdb).

I tend to go to the system tables for my information, anyway.

Here is what the new version looks like:

1> sp_helpdb mdb3
2> go
 name                     db_size       owner                    dbid  
        created       
        status                                                                  
                              
 ------------------------ ------------- ------------------------ ------
        --------------
        ------------------------------------------------------------------------
------------------------------
 mdb3                         1200.0 MB dhancock                      5
        Apr 01, 1999  
        select into/bulkcopy/pllsort                                            
                              

(1 row affected)
 name                           attribute_class               
        attribute                      int_value  
        char_value                                                              
                                                                                
                                                                                
                       
        comments                                                                
                                                                                
                                                                                
                       
 ------------------------------ ------------------------------
        ------------------------------ -----------
        ------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
        ------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------
 mdb3                           buffer manager                
        cache binding                            1
        mdb3_cache                                                              
                                                                                
                                                                                
                       
        NULL                                                                    
                                                                                
                                                                                
                       

 device_fragments               size          usage               
        free kbytes     
 ------------------------------ ------------- --------------------
        ----------------
 db_disk                        100.0 MB      data only           
                   86322
 db_disk                        300.0 MB      data only           
                   46444
 db_disk                        300.0 MB      data only           
                  304976
 db_disk2                       100.0 MB      data only           
                  102000
 db_disk2                       200.0 MB      data only           
                   40822
 log_disk1                      100.0 MB      log only            
        not applicable  
 log_disk1                      100.0 MB      log only            
        not applicable  

                                                               
 --------------------------------------------------------------
 log only free kbytes = 126720                                 

 device                        
        segment                                                                 
                  
 ------------------------------
        ------------------------------------------------------------------------
------------------
 db_disk                       
        default                                                                 
                  
 db_disk                       
        system                                                                  
                  
 db_disk2                      
        index_seg                                                               
                  
 log_disk1                     
        logsegment                                                              
                  

(return status = 0)

-----
"Computeri non cogitant, ergo non sunt"