Results 1 to 2 of 2

Thread: Two questions

  1. #1
    Join Date
    Oct 2003

    Unanswered: Two questions

    I have two questions.
    1) If a database is suspect we can have that trace from sysdatabases.There is a column named status.My question is in case of suspect datatbase what will be value in the field status of sysdatabases?
    2) The password of an user login(created by using sp_addlogin stored procedure or any other way) is stored in the table sysxlogins of master database.The password is stored in a varbinary format.How can I get the actual password(means in a char format)?I mean how can I convert the varbinary value to a readable format?

  2. #2
    Join Date
    Mar 2004
    For 2), the varbinary format is the encrypted format. There is no official method or tools to decrypt it simply. But if you find an unofficial tool, I'm interested !

Posting Permissions

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