sp_helpdb in sybase

Question

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

I m using sybase Adaptive Server Enterprises

Why this happend plz help me

Thanks in advance

Answer 1

Both sets are returned however where they are displayed depends on which tool you're using to run the query. If you're using SQL Advantage or ASEISQL, then you need to look in the results and the messages windows to get the full answers. If you're using the command line ISQL then all will be returned together.

It's because some of the results are returned from a select, and some from print messages.

print "Print hello"

select "Select hello"

Try running the above and you'll hopefully find where each different output is displayed in your tool.

If you're using SQL Advantage see the SQL Advantage image here, this shows the options screen in which you can change how your results return. The "Display Print Messages with Results" might help in this case.