Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    4

    Unanswered: sp_helpdb in sybase

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    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.
    I'm not crazy, I'm an aeroplane!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •