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

    Unanswered: Needed help in sybase

    Dear Friend, I need to retrive the following Details using Sybase SQL Query.

    1).Database Data File Path

    2).Database Transaction Log File Path

    3).Path where SybaseSoftware Installed

    4).Patch Installed on Sybase

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Try the systemtables in the masterdatabase and/or sp_configure. The documentation should give some information about this stuff too.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Aug 2010
    Posts
    19
    For your first 2 questions:

    select t1.name,t1.phyname,t1.status,t2.lstart,t2.size,t2. unreservedpgs
    from master..sysdevices t1
    inner join master..sysusages t2 on t1.vdevno = t2.vdevno
    where dbid =db_id()
    order by 1,2,4

    from this site:
    Sybase Blog sybdoc.com

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    For version and ebf number
    select @@version

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
  •