sp_helpdb in sybase

maxyogesh2002 · #1 (**permalink**) 11-01-10, 02:58

Dear Friends
when i run sp_helpdb dbname query in sybase it return only following columns

name,db_size,owner,dbid,created,status

& not returning the following Columns

device_fragments,size,usage,created,free kbytes

Why this happend plz help me

Thanks in advance

Martijnvs · #2 (**permalink**) 11-01-10, 04:00

Because those columns aren't selected in the stored procedure sp_helpdb, obviously. If you want the values of the other columns, do a select on a few systemtables, or try some other stored procs.

Internet Services

Web Development

Digital Marketing

Consumer Tech