Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    7

    Unanswered: Checking Single Mode and Offline Mode.


    A.
    In Sybase, how should I check whether my database is in single user mode ?
    Here I would like to check with 'status' variable in master..sysdatabases.
    If status = 4096, then Should I consider db as single user mode ?


    B.
    In Sybase, how should I check whether my database is in offline state ?
    Here I would like to check with 'status2' variable in master..sysdatabases.
    If (status2 & 30) != 0, then Should I consider db as offline mode ?

    Thanks.
    Regards,
    Amol

  2. #2
    Join Date
    Nov 2003
    Posts
    10

    database status.

    A simple system stored procedure should help you..

    sp_helpdb <dbname>

    HTH

Posting Permissions

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