Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    133

    Unanswered: db devices reside

    hi,
    just newbie here. i'm beginning to understand sybase a few months already. anyone can help me identify active devices for each databases separated with log and data aside from the command sp_helpdevice and sp_helpdb. i'm looking for a select statement to trace active devices for my databases.
    thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    What do you consider an 'active' device? All devices that a database resides on are basicly active, so sp_helpdb should give you all the info.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Feb 2012
    Posts
    133
    tnx for the reply.
    active device for data and log of each of my databases.. just need to determine the one using of my database

Posting Permissions

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