Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    22

    Unanswered: how do I obtain Sybase database option information...

    I know of the existence of the sp_dboption function however, as far as I can tell, it can only be used to either

    a.) list all the available database option names or
    b.) change the status of an individual database option

    However, I'm want to retrieve the current status for each database option on a per database basis. Can somebody please tell me how I can do this, using the sp_dboption function or otherwise?

    - Garry

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    sp_helpdb yourDB

    You may be able to look at the source for those two procedures to see where it is grabbing the DB options and create a SQL statement yourself.

    However I would agree that sp_dboption should return the parameter's value if you do something like the following:
    sp_helpdb, your_db, parameter

    It would seem intuitive to do it that way, but I'm pretty sure you can't.
    Thanks,

    Matt

Posting Permissions

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